hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1002) multi-partition inserts
Date Mon, 21 Dec 2009 08:48:18 GMT
multi-partition inserts
-----------------------

                 Key: HIVE-1002
                 URL: https://issues.apache.org/jira/browse/HIVE-1002
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: Zheng Shao


We should allow queries like this into a partitioned table:

{code}
CREATE TABLE (a STRING, b STRING, c STRING)
PARTITIONED BY (ds STRING, ts STRING);

INSERT OVERWRITE TABLE x PARTITION (ds = '2009-12-12')
SELECT a, b, c, ts FROM xxx;
{code}

Basically, allowing users to overwrite multiple partitions at a time.
The partition values specified in PARTITION part (if any) should be a prefix of the partition
keys.
The rest of the partition keys goes to the end of the SELECT expression list.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message