[jira] [Commented] (HIVE-109) 'location' clause for table creation should only be allowed for external tables

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

    [ 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