[
https://issues.apache.org/jira/browse/HIVE-11745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744107#comment-14744107
]
Yongzhi Chen commented on HIVE-11745:
-------------------------------------
[~szehon], sorry I can not find what's your last question is in the review
board. Is that adding the permission test? (It is in the patch 2).
The test was a CliDriver test in patch 1 which seemed fine with me. It is true,
it will fail in the minimr test for it only does not work with hdfs file system
without the fix, the CliDriver test works fine for it uses local file system.
Thanks
> 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)
