hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Craig Swift (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2888) Creating an external table using the 'LIKE' clause actually creates a managed table.
Date Wed, 21 Mar 2012 16:43:51 GMT
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

        

Mime
View raw message