Re: Passing variables using Hiveconf

2014-08-22 Thread karthik Srivasthava
Nithin , It worked when i set hive.variable.substitute=true; every time i run this query.. thanks buddy On Fri, Aug 22, 2014 at 1:08 PM, Nitin Pawar wrote: > this is one way > > hive $HIVEPARAMS -hiveconf target="$var1" -hiveconf > mapred.child.java.opts="-server -Xmx1200m -Djava.net.preferIPv

Re: Passing variables using Hiveconf

2014-08-22 Thread Nitin Pawar
this is one way hive $HIVEPARAMS -hiveconf target="$var1" -hiveconf mapred.child.java.opts="-server -Xmx1200m -Djava.net.preferIPv4Stack=true" and you need to set this variable set hive.variable.substitute=true; On Fri, Aug 22, 2014 at 9:24 PM, karthik Srivasthava < karthiksrivasth...@gmail.c

Passing variables using Hiveconf

2014-08-22 Thread karthik Srivasthava
Hi, I am passing substitution variable using hiveconf in Hive.. But i couldnt execute simple queries when i am trying to pass more than one parameter. It throws NoViableAltException - AtomExpression.. Am i missing something.?