Re: Alter table partition rename with location - moves partition back to hive warehouse

2017-03-22 Thread Ying Chen
I think the usage scenario for external tables generally indicates that Hive does not try to manage it - and so it makes sense not to move tables or change its names... See external table: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ExternalTables See ren

Re: Alter table partition rename with location - moves partition back to hive warehouse

2017-03-21 Thread Pushkar.Gujar
An extension to below problem, I have noticed something else too in Hive 2.1.0. If I create a *external* table with specific location and with partitions, after renaming the partition, the underline folder names do not change. ​for e.g - insert into test_local_part partition (col2=1) values (1)