trafodion-general team mailing list archive

[Yiyang Dai <daiyiyang@xxxxxxxxxxx>]

Hello Susan & Paul,
Thanks for pointing sql ref manual.one more question, can trafodion sql access hive table directly ?
from the manual, hive data can be access only through LOAD statement with hive.hive schema,is this apply to SELECT statement also ?
Regards,Yiyang
From: Susan.Sandstrom@xxxxxx
To: pchin@xxxxxx; daiyiyang@xxxxxxxxxxx; trafodion-general@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Trafodion-general] native hbase table mapping support ?
Date: Tue, 28 Oct 2014 16:30:46 +0000









Hi, Yiyang and others,
 
Here’s a link to the latest version of the
Trafodion SQL Reference Manual: 
http://docs.trafodion.org/Trafodion_SQL_Reference_Manual_0.9.0.pdf. For future reference, you can find all the Trafodion manuals and other documentation on this wiki page:
https://wiki.trafodion.org/wiki/index.php/Documentation.
 
Thanks,
 
Susan
 
 


From: Trafodion-general [mailto:trafodion-general-bounces+susan.sandstrom=hp.com@xxxxxxxxxxxxxxxxxxx]
On Behalf Of Chin, Paul (COE)

Sent: Monday, October 27, 2014 10:33 PM

To: Yiyang Dai; trafodion-general@xxxxxxxxxxxxxxxxxxx

Subject: Re: [Trafodion-general] native hbase table mapping support ?


 
Hi Yiyang:
 
It doesn’t require mapping.  All hbase tables is accessible from within trafodion.
 
Access to native HBase tables has to be in ROW or CELL format.
This is described better in Page 19 of the manual
http://docs.trafodion.org/Trafodion_SQL_Reference_Manual_0.8.0.pdf
 
Example: accessing a hbase native table call time.dim
 
>>select count(*) from hbase."_ROW_"."time_dim";
 
(EXPR)
--------------------
 
               86400
 
--- 1 row(s) selected.
Example:
 
by table name hbase.hbase.<actual hbase table name>.
 
 
Paul
 


From: Trafodion-general [mailto:trafodion-general-bounces+pchin=hp.com@xxxxxxxxxxxxxxxxxxx]
On Behalf Of Yiyang Dai

Sent: Tuesday, 28 October 2014 4:10 PM

To: trafodion-general@xxxxxxxxxxxxxxxxxxx

Subject: [Trafodion-general] native hbase table mapping support ?


 


Hello,


 


When go through trafodion FAQ, I saw:


 


"With Trafodion, customers can get full capabilities to be able to use standard HBase APIs as well as use Trafodion for SQL access to the HBase tables. This includes Trafodion's ability to
 use powerful SQL capabilities to do joins against both HBase and Trafodion tables and run queries against them while providing transaction management capability. "


 


To understand this more precisely, does this mean that a native hbase table can be mapped to a trafodion table while user can run trafodion SQL on top of it ?


 


Regards,


Yiyang