hive映射hbase外部表操作

1. 示例

CREATE EXTERNAL TABLE
default.user_regionalization(key string,uid string,followersCount int)
STORED BY &＃39;org.apache.hadoop.hive.hbase.HBaseStorageHandler&＃39;
WITH SERDEPROPERTIES (
"hbase.columns.mapping"&＃61;":key,
fn:uid,
fn:followersCount")
TBLPROPERTIES("hbase.table.name" &＃61; "crawl:user_regionalization");


2. 注释
   default.user_regionalization //命名空间.hive表名
   STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’ //类似引入hbase依赖
   TBLPROPERTIES(“hbase.table.name” &＃61; “crawl:user_regionalization”); //hbase对应命名空间.表

3. 注意
   两张表的字段需要一一对应&＃xff0c;类型可以在hive随意设置