CREATE EXTERNAL TABLE hbase_dcs(
key string comment “hbase rowkey”,
station string comment “站”,
area string comment “区”,
moduleId string comment “模块ID”,
moduleName string comment “模块名字”,
name string comment “kks名字”,
kks string comment “kks编码”,
value string comment “kks内容”,
`date` string comment “时间”
)
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (“hbase.columns.mapping” = “:key,dcs:station,dcs:area,dcs:moduleId,dcs:moduleName,dcs:name,dcs:kks,dcs:value,dcs:date”)
TBLPROPERTIES(“hbase.table.name” = “qzwl_dcs”);
解读:
hbase_dcs 为你在hive中的名
以下为hive中的字段
key string comment “hbase rowkey”,
station string comment “站”,
area string comment “区”,
moduleId string comment “模块ID”,
moduleName string comment “模块名字”,
name string comment “kks名字”,
kks string comment “kks编码”,
value string comment “kks内容”,
`date` string comment “时间”
以下为hbase中的字段与hive中的字段一一对应,dcs为列簇
“hbase.columns.mapping” = “:key,dcs:station,dcs:area,dcs:moduleId,dcs:moduleName,dcs:name,dcs:kks,dcs:value,dcs:date”
qzwl_dcs为hbase中的表名
“hbase.table.name” = “qzwl_dcs”