[jira] [Commented] (HIVE-6133) Support partial partition exchange

["Naveen Gangam (JIRA)" <ji...@apache.org>]

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

Naveen Gangam commented on HIVE-6133:
-------------------------------------

[~navis] Should we revisit this improvement? From this feature documentation page at https://cwiki.apache.org/confluence/display/Hive/Exchange+Partition,
{{When the command is executed, the source table's partition folder in HDFS will be renamed to move it to the destination table's partition folder.}}

When exchanging a partition into a already partitioned table, what will the order of the partition keys be for the destination table? What will happen to existing partitions on the source table that only had single partition key when it was created? Thanks

> Support partial partition exchange
> ----------------------------------
>
>                 Key: HIVE-6133
>                 URL: https://issues.apache.org/jira/browse/HIVE-6133
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-6133.1.patch.txt
>
>
> Current alter exchange coerces source and destination table to have same partition columns. But source table has sub-set of partitions and provided partition spec supplements to be a complete partition spec, it need not to be that.
> For example, table into partition 
> {noformat}
> CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING);
> CREATE TABLE exchange_part_test2 (f1 string) 
> ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2;
> {noformat}
> or 
> partial partitions into parent partition
> {noformat}
> CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING);
> CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (hr STRING)
> ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2;
> {noformat}
> can be possible.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)