1

Have created a table using:

 )   
ROW FORMAT SERDE 'com.bizo.hive.serde.csv.CSVSerde'
with serdeproperties(
"field.delim"="|"
)

When I tried to upload a file, that is comma-delimited, it has been uploaded correctly. How is it possible, if I had configured pipe as a delimiter for the data? Does csv-Serde has some "smart" way of identifying the delimiter?

leftjoin
  • 36,950
  • 8
  • 57
  • 116
Anastasia
  • 25
  • 1
  • 4

1 Answers1

0

As per documentation valid CSVSerde properties are 

   "separatorChar" = "\t",
   "quoteChar"     = "'",
   "escapeChar"    = "\\"

Default separator, quote, and escape characters if unspecified

DEFAULT_ESCAPE_CHARACTER \
DEFAULT_QUOTE_CHARACTER  "
DEFAULT_SEPARATOR        ,

field.delim is not supported property which is ignored and it uses default setting. This property is valid for another SerDe MultiDelimitSerDe

leftjoin
  • 36,950
  • 8
  • 57
  • 116