Creating an external table using the 'LIKE' clause actually creates a managed
table.
------------------------------------------------------------------------------------
Key: HIVE-2888
URL: https://issues.apache.org/jira/browse/HIVE-2888
Project: Hive
Issue Type: Bug
Components: Metastore
Affects Versions: 0.7.1
Reporter: Craig Swift
When creating a new table with both the EXTERNAL and LIKE clauses, the new
table does not behave as an EXTERNAL table thus resulting in potential data
loss.
Example:
create external table test1 (VAL string) location '/user/craig/test1';
create external table test2 like test1 location '/user/craig/test2';
drop table test1;
/user/craig/test1 - still exists
drop table test2;
/user/craig/test2 - is deleted (bad)
If I do an extended describe on both tables, test1 shows up as being external
while test2 is a managed table.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira