Support Questions

Find answers, ask questions, and share your expertise

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