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

["Prasad Chakka (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12754371#action_12754371 ] 

Prasad Chakka commented on HIVE-109:
------------------------------------

I think there are quite a few people who use this feature and those usecases will break by fixing this. But I don't see any problem here, if users don't want their data to be deleted with the table they can use EXTERNAL flag otherwise they will not use it. It does not matter whether 'location' has been specified or not.

> '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: Hadoop Hive
>          Issue Type: Bug
>          Components: 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.
-
You can reply to this email to add a comment to the issue online.