Navis created HIVE-6133:
---------------------------

             Summary: 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


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, 
{nofomat}
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;
{nofomat}

or 

{nofomat}
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;
{nofomat}

can be possible.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to