Phoenix映射已存在的Hbase表

目录

 

1、映射HBase表只需要下面三个信息，Phoenix建表的时候rowkey可以随意字符

2、Phoenix创建视图表

3、Phoenix验证

4、HBase验证

---

1、映射HBase表只需要下面三个信息，rowkey可以随意字符

表名：T_GW

列簇名：attribute，behavior

字段名：create_time 等等。。。

咋获取以上信息呢？

describe ‘表名’ 获取列簇名

get 或者scan ‘表名’ 获取字段名

hbase(main):002:0> describe 'T_GW'
Table T_GW is ENABLED                                                                                                                                                                                                                                           
T_GW, {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2 => '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|805306366|', coprocessor$3 => '|org.apache.phoenix.coprocessor.
GroupedAggregateRegionObserver|805306366|', coprocessor$4 => '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|'}                                                                                                                            
COLUMN FAMILIES DESCRIPTION                                                                                                                                                                                                                                     
{NAME => 'attribute', BLOOMFILTER => 'NONE', VERSIONS => '3', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'false', BLOCKSIZE => '65536', REP
LICATION_SCOPE => '0'}                                                                                                                                                                                                                                          
{NAME => 'behavior', BLOOMFILTER => 'NONE', VERSIONS => '3', IN_MEMORY