[jira] [Created] (HIVE-12347) Different tables' external partitions can point to the same location without any warning or error

["Anne Yu (JIRA)" <ji...@apache.org>]

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)