[IMPALA-741] Impala forgets about partitions with non-existant locations

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.2.3
• Fix Version/s: Impala 1.4
• Assignee: Henry Robinson
• Reporter: Henry Robinson
• Created: 11/Jan/14 00:48
• Updated: 04/Jun/14 17:22
• Resolved: 04/Jun/14 17:22

Description

[localhost:21000] > create table b(col int) partitioned by (p int);
Query: create table b(col int) partitioned by (p int)

Returned 0 row(s) in 0.15s
[localhost:21000] > insert into b partition(p) values(1,2);
Query: insert into b partition(p) values(1,2)
Inserted 1 rows in 0.39s
[localhost:21000] > alter table b partition(p=2) set location "/tmp/baf"; <-- Doesn't exist
Query: alter table b partition(p=2) set location "/tmp/baf"
[localhost:21000] > alter table b partition(p=2) set location "/tmp/baf";
Query: alter table b partition(p=2) set location "/tmp/baf"
ERROR: AnalysisException: Partition spec does not exist: (p=2).

Issue Links

• is related to: IMPALA-624 Impala does not use a partition's HDFS path as the sink location for INSERT queries, instead uses the parent table's location