Re: hivevar in partition clause

2017-03-21 Thread Furcy Pin
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

2017-03-21 Thread Brotanek, Jan
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