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;