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

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

     [ https://issues.apache.org/jira/browse/HIVE-12347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anne Yu updated HIVE-12347:
---------------------------
    Affects Version/s: 1.2.1
          Component/s: Hive

> 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
>          Components: Hive
>    Affects Versions: 1.2.1
>            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)