trafodion-general team mailing list archive

["Chin, Paul (COE)" <pchin@xxxxxx>]

Yes you can.

example
Select * from hive.hive.<hive table name>;

From: Yiyang Dai [mailto:daiyiyang@xxxxxxxxxxx]
Sent: Wednesday, 29 October 2014 5:18 PM
To: Sandstrom, Susan; Chin, Paul (COE); trafodion-general@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Trafodion-general] native hbase table mapping support ?

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<mailto:Susan.Sandstrom@xxxxxx>
To: pchin@xxxxxx<mailto:pchin@xxxxxx>; daiyiyang@xxxxxxxxxxx<mailto:daiyiyang@xxxxxxxxxxx>; trafodion-general@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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