Hive映射HBase数据源

CREATE EXTERNAL TABLE `mongodb_dingtalk.hbasetohive_patent`(  
key String,  
abstracts String,  
address String)  
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'  
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:abstracts,info:address")  
TBLPROPERTIES("[hbase.table.name](http://hbase.table.name/)" = "dingtalk:patent");

仅从HBase拉取数据使用，禁止利用此种方式往HBase写数据

数据拉出时拉出hbase中数据对应当前版本的时间戳

create external table ods.ods_zxk_hbase_wechat_public_account_mapping(  
id string comment '需要拆分的key',  
ts timestamp comment '数据标识符，用来跟新数据做去重')  
comment '高级搜索有无微信公众号'  
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'  
WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,:timestamp')  
TBLPROPERTIES('[hbase.table.name](http://hbase.table.name/)' = 'dingtalk:wechat_public_account')