You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2011/05/02 19:27:03 UTC
[jira] [Updated] (HIVE-2086) Data loss with external table
[ https://issues.apache.org/jira/browse/HIVE-2086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang updated HIVE-2086:
-----------------------------
Status: Open (was: Patch Available)
> 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
> Assignee: Jonathan Natkins
> Attachments: HIVE-2086.1.patch, HIVE-2086.2.patch, create_like.q.out
>
>
> 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