[HIVE-15400] EXCHANGE PARTITION should honor partition locations

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Anthony Hsu
• Created: 09/Dec/16 01:15
• Updated: 09/Dec/16 01:15

Description

Currently, if you add a partition with a custom location, EXCHANGE PARTITION will fail with a "File ... does not exist" error:

drop table if exists text_partitioned;
drop table if exists text_partitioned2;

create table text_partitioned (b string) partitioned by (a int) stored as textfile;
create table text_partitioned2 (b string) partitioned by (a int) stored as textfile;

alter table text_partitioned add partition (a=1) location '/tmp/text/1';

alter table text_partitioned2 exchange partition (a=1) with table text_partitioned;

The last command fails with

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.io.FileNotFoundException File file:/path/to/warehouse_dir/text_partitioned/a=1 does not exist)

EXCHANGE PARTITION should honor the location that has been set for the partition.