Trafodion访问原生HBase表

Trafodion中所有的原生HBase表都拥有相同的表结构，通过Trafodion访问原生HBase表有两种模式：ROW和CELL。

下面通过一个例子简单介绍如何通过Trafodion来访问原生的HBase表。

1 HBase Shell下创建测试表并插入一条记录

hbase(main):001:0> create 'nativetab','colfam1'
0 row(s) in 0.4610 seconds

=> Hbase::Table - nativetab
hbase(main):002:0> put 'nativetab','row1','colfam1:col1',
hbase(main):003:0* 'val1'
0 row(s) in 0.1370 seconds

hbase(main):004:0> scan 'nativetab'
ROW                                COLUMN+CELL
 row1                              column=colfam1:col1, timestamp=1475892882126, value=val1
1 row(s) in 0.0270 seconds.

2 Trafodion CLI 通过CELL模式访问上述表

SQL>select * from hbase."_CELL_"."nativetab";

ROW_ID                                                                                               COL_FAMILY                                                                                           COL_NAME                                                                                             COL_TIMESTAMP        COL_VALUE                                                                  
---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- -------------------- --------------------------------------------------------------------------------------------------------------------------------
row1                                                                                                 colfam1                                                                                              col1                                                                                                        1475892882126 val1                                                                       

--- 1 row(s) selected.

3 Trafodion CLI 通过ROW模式访问上述表

SQL>select * from hbase."_ROW_"."nativetab";

ROW_ID                                                                                               COLUMN_DETAILS                  
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
row1
colfam1:col1val1

--- 1 row(s) selected.