Hive中创建hbase关联表范例

CREATE TABLE hive_hbase_emp_table(
empno int,
ename string,
job string,
mgr int,
hiredate string,
sal double,
comm double,
deptno int)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = 
":key,
info:ename,
info:job,
info:mgr,
info:hiredate,
info:sal,
info:comm,
info:deptno")
TBLPROPERTIES ("hbase.table.name" = "hbase_emp_table");