Define variables in Impala

[#1]

Hi experts,

Is it possible to define variables in a query? something like "variable myvariable NUMBER"?

And, is it possible to define queries with "with .... as" like in Oracle db?

Thanks in advance

[#2 · Accepted solution]

1. No

2. Yes - http://www.cloudera.com/content/cloudera/en/documentation/cloudera-impala/latest/topics/impala_with....

[#3]

Thanks!

[#4]

I still can't find a solution to the issue, the url posts are no longer available, can you help me how to define a date variable in IMPALA ?, From HIVE I can do it, but I needed to define a variable in IMPALA

[#5]

Hi @Crisj0615, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.