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,

PA, the answer I would guess is that you can't. I tried to do it against Netezza, but no such luck.

Rgds
Håkan

Well, it was very easy actually...

SET SQLENGINE = SQLHIV
SQL SET SERVER HIVE
-RUN

SQL SQLORA PREPARE XPTO FOR SELECT COUNT(*)... 

tks,
PA