Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL PREPARE
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL PREPARE
 Login/Join
 
Member
posted
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,


Release : 8.0.02
OS : Linux
App Server : Tomcat
all output
 
Posts: 23 | Registered: June 26, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
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


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Well, it was very easy actually...

SET SQLENGINE = SQLHIV
SQL SET SERVER HIVE
-RUN

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


tks,
PA


Release : 8.0.02
OS : Linux
App Server : Tomcat
all output
 
Posts: 23 | Registered: June 26, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL PREPARE

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.