Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Impala Dynamic SQL

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar

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

View solution in original post

4 REPLIES 4

avatar

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

avatar
Contributor

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

http://www.hplsql.org/execute

avatar
Explorer

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

avatar
Contributor

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