hive映射hbase

一 hive中建表映射hbase

create external table eventskb07.hb_user_friend(row_key STRING,
user_id STRING,
friend_id STRING)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with serdeproperties ('hbase.columns.mapping'=':key, uf:userid, uf:friendid')
tblproperties ('hbase.table.name' = 'events_db:user_friends');

二 建立ORC表

create table eventskb07.user_friend
stored as orc as
select * from eventskb07.hb_user_friend;