hive表如何使用多字符分隔
方法1:
hive> create external table t4(id INT, name STRING)
> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe'
> WITH SERDEPROPERTIES ("field.delim"="$%#")
> location '/user/hive/warehouse/t3';
OK
Time taken: 0.045 seconds
hive> select * from t4;
OK
1 aaa
2 bbb
3 ccc
Time taken: 0.092 seconds, Fetched: 3 row(s)
方法2
hive> create external table t5(a string, b string)
> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
> WITH SERDEPROPERTIES ("input.regex" = "^(.*)\\$\\%\\#(.*)$")
> location '/user/hive/warehouse/t3';
OK
Time taken: 0.046 seconds
hive> select * from t5;
OK
1 aaa
2 bbb
3 ccc
Time taken: 0.09 seconds, Fetched: 3 row(s)