使用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”);
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交