Hive读取Hbase数据(实战篇)

对应的HiveSQL

CREATE EXTERNAL TABLE `ods_xx`(
`uid` string COMMENT 'xx',
`main_img` string COMMENT 'xx',
`img_byte` string COMMENT 'xx'
)
ROW FORMAT SERDE
'org.apache.hadoop.hive.hbase.HBaseSerDe'
STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'colelction.delim'=',',
'hbase.columns.mapping'=':key,f1:mi,f1:ib',
'serialization.format'='1')
TBLPROPERTIES (
'hbase.table.name'='namespace:tablename');