[HIVE-6022] Load statements with incorrect order of partitions put input files to unreadable places

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Teruyoshi Zenmyo
• Reporter: Teruyoshi Zenmyo
• Created: 12/Dec/13 14:12
• Updated: 16/Dec/13 15:04
• Resolved: 16/Dec/13 15:04

Description

Load statements with incorrect order of partitions put input files to incorrect paths.

CREATE TABLE test_parts (c1 string, c2 int) PARTITIONED BY (p1 string,p2 string);
LOAD DATA LOCAL INPATH '/opt/hive/examples/files/kv1.txt' OVERWRITE INTO TABLE test_parts PARTITION (p2='p1', p1='p2')"

The input file is located as below and the data is not readable.

% find /user/hive/warehouse/test_parts/
/user/hive/warehouse/test_parts/
/user/hive/warehouse/test_parts//p1=p2
/user/hive/warehouse/test_parts//p1=p2/p2=p1
/user/hive/warehouse/test_parts//p2=p1
/user/hive/warehouse/test_parts//p2=p1/p1=p2
/user/hive/warehouse/test_parts//p2=p1/p1=p2/.kv1.txt.crc
/user/hive/warehouse/test_parts//p2=p1/p1=p2/kv1.txt