背景:需要将HBase中表xyz(列簇cf1,列val)迁移至Hive
1. 建立Hive和HBase的映射关系
1.1 运行hive shell进入hive命令行模式,运行如下脚本
CREATE EXTERNAL TABLE hbase_table_1(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
TBLPROPERTIES ("hbase.table.name" = <