Hive关联表

使用Hive时，创建关联表
CREATE EXTERNAL TABLE hisdata201908(key string, di string,dn string,li int,ln string,
mi string,mk string,mn string,mv string,pn string,rt string,sn string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’
LINES TERMINATED BY ‘\n’
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (“hbase.columns.mapping” = “:key,d:di,d:dn,d:li,d:ln,d:mi,d:mk,d:mn,d:mv,d:pn,d:rt,d:sn”)
TBLPROPERTIES (“hbase.table.name” = “hisdata201908”);