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')
Impala does not support dynamic SQL. I am not 100% sure about Hive, but I doubt Hive support it.
Hive 2.0.0 includes HPL/SQL, which includes an execute function for dynamic SQL:
Interesting, is the HPL/SQL feature of Hive 2.0 available in CDH 5.7?
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: