hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Q Long (JIRA)" <>
Subject [jira] [Commented] (HIVE-2086) Data loss with external table
Date Thu, 31 Mar 2011 18:30:06 GMT


Q Long commented on HIVE-2086:

It seems that "create external table like"  does not preserve the external property.  

Note that both the original table S and the new table T are external, and data loss will only
occur when creating T using statement
"create external table T like S location L".  No data loss if T with full table definitions
(i.e, does not use like statement)

> Data loss with external table
> -----------------------------
>                 Key: HIVE-2086
>                 URL:
>             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:

View raw message