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

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)

Re: hivevar in partition clause

Hello Jan, I guess this is because you wrote ${hivevar=PNAME} with an = instead of a : regards, Furcy On Tue, Mar 21, 2017 at 5:50 PM, Brotanek, Jan wrote: > Hi, I have following shell script: > > > > #!/bin/bash > > PNAME=20170320_203225 > > TNAME=tablea1 > > /usr/bin/hive -hiveconf hive.cli

hivevar in partition clause

Hi, I have following shell script: #!/bin/bash PNAME=20170320_203225 TNAME=tablea1 /usr/bin/hive -hiveconf hive.cli.errors.ignore=true -hivevar PNAME=$PNAME -hivevar TNAME=$TNAME -v -f ./query.hql Trying to pass PNAME hivevar to query.hql script: insert into table a1.${hivevar:TNAME}_orc PARTIT