search

ogrodnek / csv-serde

Hive SerDe for CSV
Apache License 2.0
141 stars 80 forks source link

CSV with double quotes and semicolon #6

Closed janmechtel closed 11 years ago

janmechtel commented 12 years ago

First of all thanks for this serde, it's exactly what's missing in hive and very useful.

I'm trying to get it to work with double quotes " as quote chars and semicolon ; as separator

ROW format serde 'com.bizo.hive.serde.csv.CSVSerde'
with serdeproperties (
  "separatorChar" = "\\;",
  "quoteChar"     = '"'
 )

I've tried different ways of putting the semi-colon and the quote char, any pointers which way should work?

haydenth commented 11 years ago

I'm having the same issue (I wonder if we're both trying to format files from the same source, haha). Did you have any luck with this?

janmechtel commented 11 years ago

Not sure how I solved this, but this is what I am using now:

row format serde 'com.bizo.hive.serde.csv.CSVSerde'

with serdeproperties (
 "separatorChar" = ';',
 "quoteChar"     = '"'
)