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