question Re: Define variables in Impala in Archives of Support Questions (Read Only)

Define variables in Impala

sargebugman — Fri, 16 Sep 2022 09:20:19 GMT

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

Re: Define variables in Impala

UkrZilla — Mon, 26 Jan 2015 14:00:11 GMT

1. No

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

Re: Define variables in Impala

sargebugman — Mon, 26 Jan 2015 15:45:00 GMT

Thanks!

Re: Define variables in Impala

Crisj0615 — Thu, 04 Feb 2021 16:52:39 GMT

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

Re: Define variables in Impala

VidyaSargur — Fri, 05 Feb 2021 05:34:52 GMT

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.