Reply
Explorer
Posts: 12
Registered: ‎05-20-2016
Accepted Solution

Impala Dynamic SQL

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

Cloudera Employee
Posts: 307
Registered: ‎10-16-2013

Re: Impala Dynamic SQL

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

Highlighted
Explorer
Posts: 11
Registered: ‎07-10-2014

Re: Impala Dynamic SQL

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

http://www.hplsql.org/execute

Explorer
Posts: 12
Registered: ‎05-20-2016

Re: Impala Dynamic SQL

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

Explorer
Posts: 11
Registered: ‎07-10-2014

Re: Impala Dynamic SQL

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