본문 바로가기
💻Tech/🐝HIVE

[Hive] multi delimiter 테이블 DDL

by _viper_ 2023. 1. 11.
반응형

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';