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