hive查询数据送到hbase

hbase shell
新建Hbase表

create ‘account_month’,‘result’

2hive
设置hiveset hive.server2.tez.initialize.default.sessions=true;
新建hive’外部表到hbase的映射

create external table if not exists hbase_account_month(
key string,
watch_counts int,
watch_durations int,
product_counts int)
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (“hbase.columns.mapping” = “:key,result:watch_counts,result:watch_durations,result:product_counts”)
TBLPROPERTIES(“hbase.table.name” = “account_month”)

2送数据

with cte as
(
select account_id,year,month,
sum(case when types=1 then 1 else 0 end ) as watch_counts,
sum(case when types=2 then duration else 0 end) as watch_durations,
count(distinct product_id) as product_counts
from dpartition
group by account_id,year,month
)
insert into hbase_account_month
select account_id,watch_counts,watch_durations,product_counts
from cte

查询
list
scan ‘account_month’

例子2

hbase
create ‘cun_month’,‘result’

hive
set hive.server2.tez.initialize.default.sessions=true;
create external table if not exists hbase_month(
key string,
cun string
)
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (“hbase.columns.mapping” = “:key,result:cun”)
TBLPROPERTIES(“hbase.table.name” = “cun_month”)

insert into hbase_month
select month,sum(duration) from dpartition where types=2 group by month