hbase如果需要到hive里面查询的话,需要建立关联关系表才能在hive里面使用hql进行查询。
# hbase表创建hive关联表
CREATE EXTERNAL TABLE dw.adl_bd_ls_cardrat_p (
rowkey string,
createtime string,
grade string,
score string
) ROW FORMAT SERDE 'org.apache.hadoop.hive.hbase.HBaseSerDe' STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:createtime,info:grade,info:score")
TBLPROPERTIES ("hbase.table.name" = "adl_bd_ls_cardrat_p");