Support Questions
Find answers, ask questions, and share your expertise

Impala Dynamic SQL

Solved Go to solution
Highlighted

Impala Dynamic SQL

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

Accepted Solutions
Highlighted

Re: Impala Dynamic SQL

Master Collaborator

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
Highlighted

Re: Impala Dynamic SQL

Master Collaborator

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

View solution in original post

Re: Impala Dynamic SQL

Explorer

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

http://www.hplsql.org/execute

Highlighted

Re: Impala Dynamic SQL

Explorer

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

Highlighted

Re: Impala Dynamic SQL

Explorer

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