- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Impala Dynamic SQL
- Labels:
-
Apache Hive
-
Apache Impala
Created on ‎05-20-2016 10:25 PM - edited ‎09-16-2022 03:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')
Created ‎05-20-2016 10:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Impala does not support dynamic SQL. I am not 100% sure about Hive, but I doubt Hive support it.
Created ‎05-20-2016 10:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Impala does not support dynamic SQL. I am not 100% sure about Hive, but I doubt Hive support it.
Created ‎05-21-2016 09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hive 2.0.0 includes HPL/SQL, which includes an execute function for dynamic SQL:
Created ‎05-21-2016 10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Interesting, is the HPL/SQL feature of Hive 2.0 available in CDH 5.7?
Created ‎05-23-2016 08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
