hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-6133) Support partial partition exchange
Date Fri, 03 Jan 2014 04:47:51 GMT
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)

Mime
View raw message