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" = "命名空间:表名");
--这里行键和修饰符必须一一对应