Versions Compared

Old Version 2

changes.mady.by.user Szehon Ho

Saved on

compared with

New Version 3

changes.mady.by.user Lefty Leverenz

Saved on

Key

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

...

Note
titleEarliest version CSVSerde is available

The CSVSerde is available in Hive 0.14 and greater.

Background

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

Usage

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

...

Code Block
titleDefault separator, quote, and escape characters if unspecified.
DEFAULT_ESCAPE_CHARACTER \
DEFAULT_QUOTE_CHARACTER  "
DEFAULT_SEPARATOR        ,

...

The CSVSerde has been built and tested against Hive 0.14 and later, and uses Open-CSV 2.3 which is bundled with the Hive distribution.

Hive VersionsOpen-CSV Version
Hive 0.14 and later2.3