question Re: Impala Dynamic SQL in Archives of Support Questions (Read Only)

Impala Dynamic SQL

Rekonn — Fri, 16 Sep 2022 10:20:58 GMT

Is dynamic SQL possible in Impala? or Hive? And by that I mean the ability to execute a string like a statement, like:

exec ('select 1')

Re: Impala Dynamic SQL

alex.behm — Sat, 21 May 2016 05:36:07 GMT

Impala does not support dynamic SQL. I am not 100% sure about Hive, but I doubt Hive support it.

Re: Impala Dynamic SQL

mzkdm — Sat, 21 May 2016 16:31:30 GMT

Hive 2.0.0 includes HPL/SQL, which includes an execute function for dynamic SQL:

http://www.hplsql.org/execute

Re: Impala Dynamic SQL

Rekonn — Sat, 21 May 2016 17:57:24 GMT

Interesting, is the HPL/SQL feature of Hive 2.0 available in CDH 5.7?

Re: Impala Dynamic SQL

mzkdm — Mon, 23 May 2016 15:44:40 GMT

No, as CDH 5.7 includes Hive 1.1.0 plus backported fixes. But HPL/SQL is also available as a separate download and claims to work with any Hive version per their download page:

http://www.hplsql.org/download