You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ying Chen (JIRA)" <ji...@apache.org> on 2017/04/05 12:55:42 UTC
[jira] [Commented] (HIVE-16287) Alter table partition rename with
location - moves partition back to hive warehouse
[ https://issues.apache.org/jira/browse/HIVE-16287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15956793#comment-15956793 ]
Ying Chen commented on HIVE-16287:
----------------------------------
Hi Vihang -
Are you actively woking on it? if not, mind if I assign it to myself and give it a go ?
Thanks much!!!
Ying
> 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
> 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)