hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ying Chen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16287) Alter table partition rename with location - moves partition back to hive warehouse
Date Thu, 27 Apr 2017 16:39:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-16287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15986980#comment-15986980
] 

Ying Chen commented on HIVE-16287:
----------------------------------

Thank you for fixing this bug!!

> 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: 1.3.0, 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)

Mime
View raw message