使用hive查看hbase数据

为了更方便的查看hbase中的数据，甚至作为一个常规表来查看，可以使用hive进行查看，建表语句如下：

CREATE EXTERNAL TABLE alarm_from_hbase(    ts string,    alm_time string,    alm_timems int,    tag_nameid string,    alm_type int,    priid int,    alm_ack_time string,    alm_ack_timems int,    alm_group int,    alm_sub_area int,    tag_data_type string,    alm_ack_flg string,    alm_remove_flg string,    alm_remove_time string,    alm_remove_timems int,    alarm_date string)STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'  WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,cf2:alm_time,cf2:alm_timems,cf2:tag_nameid,cf2:alm_type,cf2:priid,cf2:alm_ack_time,cf2:alm_ack_timems,cf2:alm_group,cf2:alm_sub_area,cf2:tag_data_type,cf2:alm_ack_flg,cf2:alm_remove_flg,cf2:alm_remove_time,cf2:alm_remove_timems,cf2:alarm_date')TBLPROPERTIES ('hbase.table.name' = 'alarm_test');

需要注意hbase中的column family, column。

hbase表数据如下：

查询hive表：