Child pages
  • CSV Serde

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: minor edits

...

Background

The CSV SerDe is based from on https://github.com/ogrodnek/csv-serde, and was added to the Hive distribution in HIVE-7777.

 

Note
titleLimitation

This serde SerDe treats all columns to be of type String. Even if you create a table with non-string column type types using this serdeSerDe, the describe table DESCRIBE TABLE output would show string column type. The type information is retrieved from the SerdeSerDe. To convert them columns to the desired type in a table, you can create a view over the table that does the CAST to the desired type.

Usage

This SerDe works for most CSV data, but does not handle embedded newlines. To use the SerDe, specify the fully qualified class name org.apache.hadoop.hive.serde2.OpenCSVSerde.  

...