[HIVE-1002] multi-partition inserts

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.6.0
• Hadoop Flags: Reviewed
• Assignee: Ning Zhang
• Reporter: Zheng Shao
• Created: 21/Dec/09 08:46
• Updated: 17/Dec/11 00:03
• Resolved: 14/Apr/10 23:36

Description

We should allow queries like this into a partitioned table:

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;

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.

Issue Links

• duplicates: HIVE-936 dynamic partitions creation based on values