首页 > 代码库 > HIVE创建HBASE表

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")

HIVE创建HBASE表