September 05, 2014, 09:57 AM
P. Afonso[CLOSED] SQL PREPARE
Hello,
using Oracle connections we can do direct queries to the DB, syntax example:
SET SQLENGINE = SQLORA
SQL SET SERVER DBNAME
SQL SQLORA PREPARE XPTO FOR SELECT COUNT(*)...
How can i do the same but using Hive Apache Hive2 & Cloudera Impala Adapter?
tks,
PA
This message has been edited. Last edited by: P. Afonso, September 05, 2014, 10:04 AM
HåkanPA, the answer I would guess is that you can't. I tried to do it against Netezza, but no such luck.
Rgds
Håkan
September 05, 2014, 11:02 AM
P. AfonsoWell, it was very easy actually...
SET SQLENGINE = SQLHIV
SQL SET SERVER HIVE
-RUN
SQL SQLORA PREPARE XPTO FOR SELECT COUNT(*)...
tks,
PA