1、新建phoenix中的表
CREATE TABLE CAP.FMS_REF_AAA
(MSISDN VARCHAR,
PFINFO.AAA VARCHAR,
PFINFO.BBB VARCHAR,
CONSTRAINT PK_FMS_REF_ENDORSEMENT PRIMARY KEY (MSISDN)
) COLUMN_ENCODED_BYTES=‘NONE’;
PFINFO为列簇名(可自行定义)
COLUMN_ENCODED_BYTES=‘NONE’ 设置不进行编码,不加HIVE中不能显示数据。
2、在HIVE中新建外部表
CREATE EXTERNAL TABLE CAP.FMS_REF_AAA
(MSISDN string,
AAA string,
BBB string
)
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES
(“hbase.columns.mapping” = “:key,PFINFO:AAA,PFINFO:BBB”)
TBLPROPERTIES (“hbase.table.name” = “CAP:FMS_REF_AAA”);