[HIVE-16287] Alter table partition rename with location - moves partition back to hive warehouse

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 1.3.0, 2.3.0, 2.4.0, 3.0.0
• Component/s: Metastore

Environment

RHEL 6.8

• Assignee: Vihang Karajgaonkar
• Reporter: Ying Chen
• Created: 23/Mar/17 20:34
• Updated: 22/May/18 23:58
• Resolved: 21/Apr/17 18:14

Description

I was renaming my partition in a table that I've created using the location clause, and noticed that when after rename is completed, my partition is moved to the hive warehouse (hive.metastore.warehouse.dir).

create table test_local_part (col1 int) partitioned by (col2 int) location '/tmp/testtable/test_local_part';
insert into test_local_part partition (col2=1) values (1),(3);
insert into test_local_part partition (col2=2) values (3);
alter table test_local_part partition (col2='1') rename to partition (col2='4');

Running:
describe formatted test_local_part partition (col2='2')

1. Detailed Partition Information
   Partition Value: [2]
   Database: default
   Table: test_local_part
   CreateTime: Mon Mar 20 13:25:28 PDT 2017
   LastAccessTime: UNKNOWN
   Protect Mode: None
   Location: hdfs://my.server.com:8020/tmp/testtable/test_local_part/col2=2

Running:
describe formatted test_local_part partition (col2='4')

1. Detailed Partition Information
   Partition Value: [4]
   Database: default
   Table: test_local_part
   CreateTime: Mon Mar 20 13:24:53 PDT 2017
   LastAccessTime: UNKNOWN
   Protect Mode: None
   Location: hdfs://my.server.com:8020/apps/hive/warehouse/test_local_part/col2=4

—
Per Sergio's comment - "The rename should create the new partition name in the same location of the table. "