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