๐ปTech/๐HIVE
[Hive] multi delimiter ํ ์ด๋ธ DDL
_viper_
2023. 1. 11. 13:09
๋ฐ์ํ
create external table txt_test(
a string,
b string,
c string,
d string,
e string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.MultiDelimitSerDe'
WITH SERDEPROPERTIES ("field.delim"="|\001|")
LOCATION 'hdfs://name/tmp/test';