Hbase Hive整合映射

1. 创建hbase表

hbase(main):016:0> create 'hb_tgtest',{NAME => 'cf',REPLICATION_SCOPE => 1}

2．创建hive表

hive> CREATE EXTERNAL TABLE tgtest_info

(

key int,

device_id string,

lon double,

lat double,

upload_time string,

feets int,

nbcsq int,

satellites int,

battery int,

swver string

) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH

SERDEPROPERTIES ("hbase.columns.mapping" =

":key,

cf:device_id,

cf:lon,

cf:lat,

cf:upload_time,

cf:feets,

cf:nbcsq,

cf:satellites,

cf:battery,

cf:swver") TBLPROPERTIES ("hbase.table.name" = "hb_tgtest");

3.hive下加载数据

hive> insert overwrite table tgtest_info select * from tgtest;

4. hive、hbase分别查看验证

hbase(main):016:0> scan 'hb_tgtest'

hive> select * from tgtest_info;