Hive-Hbase映射

NeilVicia

已于 2022-06-19 22:34:43 修改

阅读量1.4k

点赞数 1

文章标签： hive hadoop big data hbase

于 2021-11-24 15:37:02 首次发布

本文链接：https://blog.csdn.net/liuyongsheng666/article/details/121517038

版权

本文通过实例介绍了如何在HBase中创建并使用三个列族，然后与Hive结合，创建对应的外部表，并通过Hive插入数据，展示了Hive与HBase的紧密集成。涉及的表结构包括学校信息、财务报表和学生信息，详细解释了HBaseColumnsMapping在Hive中的应用。

摘要由CSDN通过智能技术生成

hbase一张表三个列族，对应hive中三张表案例 
hbase(main):003:0> create 'kb15:school_msg','school','balance','stumsg'


create external table if not exists school_info(
id int,
name string,
schoolmaster string,
teacherNum int,
classRoom int
)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
with serdeproperties 
("hbase.columns.mapping"=":key,school:name,school:schoolmaster,school:teacherNum,school:classRoom")
tblproperties("hbase.table.name"="kb15:school_msg")

hive> insert into school_info values(1,'njzbandm','wuyadong',100,25);


create external table if not exists balance_sheet(
id int,
income float,
expend float,
year string
)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
with serdeproperties 
("hbase.columns.mapping"=":key,balance:income,balance:expend,balance:year")
tblproperties("hbase.table.name"="kb15:school_msg")

hive> insert into balance_sheet values(1,1300,1000,'2020');

create external table if not exists student_info(
id int,
java int,
bigdata int,
web int,
ui int,
cloud int,
sum int,
year string
)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
with serdeproperties 
("hbase.columns.mapping"=":key,stumsg:java,stumsg:bigdata,stumsg:web,stumsg:ui,stumsg:cloud,stumsg:sum,stumsg:year")
tblproperties("hbase.table.name"="kb15:school_msg")

hive> insert into student_info values(1,500,120,300,200,270,1390,'2020');