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 <nitinpawar...@gmail.com> wrote: > 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.com> wrote: > >> 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.? >> > > > > -- > Nitin Pawar >
