Child pages
  • CSV Serde
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Earliest version CSVSerde is available

The CSVSerde is available in Hive 0.14 and greater.


The CSV Serde is based from, and was added to Hive distribution in HIVE-7777.


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

Documentation is based on original documentation at

Create table, specify CSV properties
create table my_table(a string, b string, ...)
 row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
 with serdeproperties (
   "separatorChar" = "\t",
   "quoteChar"     = "'",
   "escapeChar"    = "\\"
 stored as textfile
Default separator, quote, and escape characters if unspecified.


For general information about SerDes, see Hive SerDe in the Developer Guide. Also see SerDe for details about input and output processing.


The CSVSerde has been built and tested against Hive 0.14 and later, and uses Super-CSV 2.2.0.

Hive VersionsSuperCSV Version
Hive 0.14 and later2.2.0
  • No labels