Hbase进阶

通过hive操作hbase的注意事项：
（1）启动yarn服务：
yarn-daemon.sh start resourcemanager
yarn-daemon.sh start nodemanager
（2）在hive中建表时附加上：
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with 
serdeproperties ("hbase.columns.mapping"=":key,列族:列名,...")
tblproperties("hbase.table.name" = "表名");

=====例1=====

--在hbase中创建表
create 'customer','order','addr'

--在hive中创建表映射
create external table customer(
name string, 
order_numb string,
order_date string,
addr_city string,
addr_state string)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with 
serdeproperties ("hbase.columns.mapping"=":key,order:numb,order:date,addr:city,addr:state")
tblproperties("hba