[
https://issues.apache.org/jira/browse/HIVE-11745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14995099#comment-14995099
]
Lefty Leverenz commented on HIVE-11745:
---------------------------------------
Doc note: Added TODOC1.3 label because use of multiple partition_specs is not
specified in the DDL wikidoc. (Also because we don't have a separate TODOC
label for 1.2.2.) This should be mentioned with version information in the DDL
doc and the Exchange Partition doc.
* [DDL -- Alter Partition -- ExchangePartition |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ExchangePartition]
* [Exchange Partition |
https://cwiki.apache.org/confluence/display/Hive/Exchange+Partition]
> 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
> Labels: TODOC1.3
> Fix For: 1.3.0, 2.0.0, 1.2.2
>
> 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)
