2021.11.24Hive-Hbase映射

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');