Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala Dynamic SQL

SOLVED Go to solution

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

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.

4 REPLIES 4

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.

Highlighted

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

Re: Impala Dynamic SQL

Explorer

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

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