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");
Hive中创建hbase关联表范例
最新推荐文章于 2023-01-27 16:00:20 发布