Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to set variables in Impala scripts

avatar
Explorer

Hi,

I'm testing some queries in Hive, and now I would like to do the same in Impala, but I don't find the way to set variables for the scripts.
For example, for Hive I do: 

hive -hiveconf DATE=1948 -f query.sql

How can I do something similar with Impala? The idea is to use the same query file.

 I'm using CDH4.4.0 with Impala 1.1.1.

 

Thanks

3 REPLIES 3

avatar
Contributor

There's not currently an impala-shell option to do such substitution. Would you mind opening a JIRA with that request at issues.cloudera.org?

 

Thanks,

John

avatar
New Contributor

Please check the JIRA raised for the above  request "How to set variable in Impala Scripts"

 

https://issues.cloudera.org/browse/IMPALA-2023

avatar
New Contributor

hi 

 

https://issues.cloudera.org/browse/IMPALA-2023 is fixed in Impala Shell v2.2

i am using Impala Shell v2.3.0 

any one know how to declare and set value to variable in script.

 

Thanks in advance