Can't pass parameters to hive script

Question

I have the next hive script:

SET LAB_MS_EXT_SCHEME='INTERAL';
set LAB_MS_EXT_SCHEME;
set ${hiveconf:name};

So I try to call this script from bash:

hive -hiveconf name=HELLLO -f myScript.hql

As a result I have the next output:

LAB_MS_EXT_SCHEME='INTERAL'
${hiveconf:name} is undefined

I will be very thankfull if somebody help me to pass parameters to hive script.

score -1 · Answer 1 · edited May 23 '17 at 11:51

-1

You need to use the hiveconf for variable substitution.Please check these link for the answer.

edited May 23 '17 at 11:51

Community

answered May 29 '15 at 12:23

Sandeep Singh

1 Answers1