[ https://issues.apache.org/jira/browse/HIVE-11745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14742807#comment-14742807 ]
Yongzhi Chen commented on HIVE-11745: ------------------------------------- The failures are not related. org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation failed more than 100 times. The 3 spark client tests failed for the same problem: java.util.concurrent.TimeoutException: null The 3 hcatalog.streaming.TestStreaming tests failed because of Table/View 'TXNS' already exists in Schema 'APP'. org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge does not relate to alter table with partition, and it passed in my local machine. {noformat} ------------------------------------------------------- Running org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.783 sec - in org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge Results : Tests run: 3, Failures: 0, Errors: 0, Skipped: 0 {noformat} > 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.2.0, 1.1.0, 2.0.0 > Reporter: Yongzhi Chen > Assignee: Yongzhi Chen > Attachments: HIVE-11745.1.patch, HIVE-11745.2.patch > > > 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)