Hive-多分隔符

ROW FORMAT  SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH  SERDEPROPERTIES ("field.delim"="*#&&&&#*")

多分隔符的实现。

CREATE TABLE test_more_split
(id int,name string,age int,tel string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH  SERDEPROPERTIES ("field.delim"="*#&&&&#*")
STORED AS TEXTFILE;