[
https://issues.apache.org/jira/browse/HIVE-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13082875#comment-13082875
]
Ashutosh Chauhan commented on HIVE-109:
---------------------------------------
What's a resolution on this? Does it mean that only significance of EXTERNAL is
that data will not be dropped on drop table and only metadata will be deleted?
> 'location' clause for table creation should only be allowed for external
> tables
> -------------------------------------------------------------------------------
>
> Key: HIVE-109
> URL: https://issues.apache.org/jira/browse/HIVE-109
> Project: Hive
> Issue Type: Bug
> Components: Metastore, Query Processor
> Reporter: Joydeep Sen Sarma
>
> currently - the code does not by and large distinguish between external and
> internal tables. one clear distinction though is that storage for external
> tables is managed outside hive. this leads to consequences like HIVE-86 - so
> that hive does not mess around with tables whose storage is managed
> externally. however - currently - we allow users to specify location for
> internal tables - which is confusing and could lead to data being deleted in
> external folders. we should not allow this.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira