Versions Compared


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



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



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.


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.