Thanks! I've created a JIRA: https://issues.apache.org/jira/browse/HIVE-16287
So, the right behavior would be to create the new partition name in the same location of the table. Thanks! On Wed, Mar 22, 2017 at 11:31 AM, Sergio Pena <sergio.p...@cloudera.com> wrote: > I don't think that behavior is correct. The rename should create the new > partition name in the same location of the table. Could you create a JIRA > for that? > > On Wed, Mar 22, 2017 at 10:24 AM, Ying Chen <ying.in...@gmail.com> wrote: > > > 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: > > >
