Write a While loop in Impala SQL?

Question

What is the syntax for writing a while loop in Impala? Is it even possible to write a loop? I cant seem to declare variables and it doesn't recognize "while" as a keyword.

None of the Hadoop sql dialects support procedural loops... What exactly are you trying to do? — OneCricketeer, Mar 28 '18 at 03:37

score 2 · Accepted Answer · answered Mar 27 '18 at 22:34

2

Impala doesn't support WHILE loops in it's syntax.

References:

Impala Reserved Words

answered Mar 27 '18 at 22:34

tk421

5,775
6
23
34

Thanks, Do you know if it supports any loop syntax? – Katie Mar 27 '18 at 23:07
Not really. If you want to do something like that you might look at `impyla` from https://github.com/cloudera/impyla. This will allow you to write looping constructs over Impala. – tk421 Mar 28 '18 at 19:31

Write a While loop in Impala SQL?

1 Answers1

Linked