[
https://issues.apache.org/jira/browse/HIVE-11745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14735603#comment-14735603
]
Yongzhi Chen commented on HIVE-11745:
-------------------------------------
The issue can not be reproduced in local setup, so it works fine with local
file system.
It can be reproduced in cluster mode. It seems that hdfs can not mkdir or
rename a folder whose parent folder does not exist. Make the fix by
creating parent folders needed. Attached the patch, the minimr test will be
failed without the fix.
> 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)
