cross posting from u...@hive.apache.org. (sorry for additional posting) I would like some opinions from the dev community relating to - if change of behavior is desired, how should it be changed ? Also, would it be better that I create a JIRA and have comments there?
Thanks much.. ------------ Hello all - 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). I was wondering, what should be the correct behavior? Should the partition be renamed and maintain on the same file system, or no name change and not moved (so treating it like if someone declared external table) ? I don't think it should be moved to hive.metastore.warehouse.dir A similar JIRA was open for renaming table: https://issues.apache.org/ jira/browse/HIVE-14909 In which, if the table is determined not belonging to /apps/hive/warehouse (ie created by location clause), then table is not moved. Thanks much! Ying ========== This is a problem for Hive 2.1 ... 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') # 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 <http://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 <http://my.server.com:8020/apps/hive/warehouse/test_local_part/col2=4> * Partition Parameters:
