HIVE创建HBASE表

CREATE TABLE card_data(
KEY string,coorid string, coorname string,cooraddr string,roadnum string,speed string
,direction string,date string,hphm string,ys string,cx string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES(
"hbase.columns.mapping"=":key,base:coorid,base:coorname,base:cooraddr,base:roadnum,base:speed
,base:direction,base:date,base:hphm,base:ys,base:cx")

posted @ 2017-06-09 18:43  黑道撒加  阅读(420)  评论(0编辑  收藏  举报