[jira] [Commented] (HIVE-11745) Alter table Exchange partition with multiple partition_spec is not working

["Andrew Sears (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15153593#comment-15153593 ] 

Andrew Sears commented on HIVE-11745:
-------------------------------------

Updated the docs.

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