Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to set variables in Impala scripts

How to set variables in Impala scripts

New Contributor

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

Re: How to set variables in Impala scripts

Cloudera Employee

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

Re: How to set variables in Impala scripts

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

Re: How to set variables in Impala scripts

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