hive映射hbase中的表

hive映射hbase中的表

create external table users(
key string,
user_id string,
locale string,
birthday string,
gender string,
joinedAt string,
location string,
timezone string    --这里可以自定义可以不和hbase上的修饰符一样
)stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with serdeproperties("hbase.columns.mapping" = ":key，行键:修饰符,base:locale,base:birthday,base:gender,base:joinedAt,base:location,base:timezone")
tblproperties("hbase.table.name"="namespace:tablename", "hbase.mapred.output.outputtable" = "命名空间:表名"); 
--这里行键和修饰符必须一一对应