[ 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)