hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anne Yu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12347) Different tables' external partitions can point to the same location without any warning or error
Date Thu, 05 Nov 2015 19:19:28 GMT
Anne Yu created HIVE-12347:
------------------------------

             Summary: Different tables' external partitions can point to the same location
without any warning or error
                 Key: HIVE-12347
                 URL: https://issues.apache.org/jira/browse/HIVE-12347
             Project: Hive
          Issue Type: Bug
            Reporter: Anne Yu


{code}
CREATE TABLE testloc1 (test STRING) PARTITIONED BY(day INT, hour INT, min INT);
CREATE TABLE testloc2 (test STRING) PARTITIONED BY(day INT, hour INT, min INT);

ALTER TABLE testloc1 add partition (day="01", hour="01", min="01") location '/hive/pipeline/data/01/01/01’;

ALTER TABLE testloc2 add partition (day="01", hour="01", min="01") location '/hive/pipeline/data/01/01/01’;
{code}

The issue is if overwrite data into testloc1 then testloc2, testloc1 data will be wiped out.
For example,

{code}
insert overwrite table testloc1 partition (day="01", hour="01", min="01") select "test1" from
test_tb;

insert overwrite table testloc2 partition (day="01", hour="01", min="01") select "test2" from
test_tb;
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message