[IMPALA-627] Alter table add partition with LOCATION clause does not work as expected.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 1.1.1, Impala 1.2
• Fix Version/s: Impala 1.2.1
• Assignee: Lenni Kuff
• Reporter: Alexander Behm
• Created: 16/Oct/13 18:25
• Updated: 12/Nov/13 23:53
• Resolved: 12/Nov/13 23:53

Description

See this forum post:
http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-IMPALA-1-1-1-1-p0-17-does-not-insert-into-partition/m-p/2195#U2195

Steps to repro:
create table foo (i int) partitioned by (year string);
alter table foo add partition (year='abcde') location '/test-warehouse/year_foo';
insert into table foo partition(year='abcde') select int_col from functional.alltypestiny;

In Hive the data is added to '/test-warehouse/year_foo'.
In Impala the data is incorrectly added to '/test-warehouse/foo/year=abcde'

I also couldn't find any tests covering this specific issue.