[ https://issues.apache.org/jira/browse/HIVE-16287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15977306#comment-15977306 ]
Vihang Karajgaonkar commented on HIVE-16287: -------------------------------------------- I think branch-1 is broken. The last pre-commit run on branch-1 based on Git log is for HIVE-15833. I see the HiveQA results similar there too. > Alter table partition rename with location - moves partition back to hive > warehouse > ----------------------------------------------------------------------------------- > > Key: HIVE-16287 > URL: https://issues.apache.org/jira/browse/HIVE-16287 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 2.1.0 > Environment: RHEL 6.8 > Reporter: Ying Chen > Assignee: Vihang Karajgaonkar > Priority: Minor > Fix For: 2.3.0, 3.0.0, 2.4.0 > > Attachments: HIVE-16287.01.patch, HIVE-16287.02.patch, > HIVE-16287.03.patch, HIVE-16287.04.patch, HIVE-16287.05-branch-1.patch, > HIVE-16287-addedum.06.patch, HIVE-16287.branch-1.01.patch > > Original Estimate: 48h > Remaining Estimate: 48h > > 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). > {quote} > 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'); > {quote} > Running: > describe formatted test_local_part partition (col2='2') > # 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') > # 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. " -- This message was sent by Atlassian JIRA (v6.3.15#6346)