Impala Dynamic SQL

[#1]

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')

[#2 · Accepted solution]

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

[#3]

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

http://www.hplsql.org/execute

[#4]

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

[#5]

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