hive建表-多分隔符

create table tmp.area (

name string,

sex string,

age string

)

ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe'

WITH SERDEPROPERTIES ("field.delim"="@#$")

;