--hive映射hbase
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ( "hbase.columns.mapping" = ":key,market:martetCount,info:provinceName")
TBLPROPERTIES( "hbase.table.name" = "province_market")
--CSV解析
row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
with serdeproperties
(
'separatorChar' = ',',
'quoteChar' = '\"',
'escapeChar' = '\\'
)
location '/app/data/exam'
--去表头
tblproperties("skip.header.line.count"="1")
hive映射hbase、hive的CSV解析、hive建表去表头
最新推荐文章于 2024-05-26 17:05:19 发布