Data loss with external table
-----------------------------
Key: HIVE-2086
URL: https://issues.apache.org/jira/browse/HIVE-2086
Project: Hive
Issue Type: Bug
Components: Metastore
Affects Versions: 0.7.0
Environment: Amazon elastics mapreduce cluster
Reporter: Q Long
Data loss when using "create external table like" statement.
1) Set up an external table S, point to location L. Populate data in S.
2) Create another external table T, using statement like this:
create external table T like S location L
Make sure table T point to the same location as the original table S.
3) Query table T, see the same set of data in S.
4) drop table T.
5) Query table S will return nothing, and location L is deleted.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira