Yongzhi Chen created HIVE-11745: ----------------------------------- Summary: Alter table Exchange partition with multiple partition_spec is not working Key: HIVE-11745 URL: https://issues.apache.org/jira/browse/HIVE-11745 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 1.1.0 Reporter: Yongzhi Chen Assignee: Yongzhi Chen
Single partition works, but multiple partitions will not work. Reproduce steps: {noformat} DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; DROP TABLE IF EXISTS t3; DROP TABLE IF EXISTS t4; CREATE TABLE t1 (a int) PARTITIONED BY (d1 int); CREATE TABLE t2 (a int) PARTITIONED BY (d1 int); CREATE TABLE t3 (a int) PARTITIONED BY (d1 int, d2 int); CREATE TABLE t4 (a int) PARTITIONED BY (d1 int, d2 int); INSERT OVERWRITE TABLE t1 PARTITION (d1 = 1) SELECT salary FROM jsmall LIMIT 10; INSERT OVERWRITE TABLE t3 PARTITION (d1 = 1, d2 = 1) SELECT salary FROM jsmall LIMIT 10; SELECT * FROM t1; SELECT * FROM t3; ALTER TABLE t2 EXCHANGE PARTITION (d1 = 1) WITH TABLE t1; SELECT * FROM t1; SELECT * FROM t2; ALTER TABLE t4 EXCHANGE PARTITION (d1 = 1, d2 = 1) WITH TABLE t3; SELECT * FROM t3; SELECT * FROM t4; {noformat} The output: {noformat} 0: jdbc:hive2://10.17.74.148:10000/default> SELECT * FROM t3; +-------+--------+--------+--+ | t3.a | t3.d1 | t3.d2 | +-------+--------+--------+--+ +-------+--------+--------+--+ No rows selected (0.227 seconds) 0: jdbc:hive2://10.17.74.148:10000/default> SELECT * FROM t4; +-------+--------+--------+--+ | t4.a | t4.d1 | t4.d2 | +-------+--------+--------+--+ +-------+--------+--------+--+ No rows selected (0.266 seconds) {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)