...
The CSV SerDe is based from https://github.com/ogrodnek/csv-serde, and was added to the Hive distribution in HIVE-7777.
Note | ||
---|---|---|
| ||
This serde treats all columns to be of type String. Even if you create a table with non string column type using this serde, the describe table output would show string column type. The type information is retrieved from the Serde. To convert them to desired type in a table, you can create a view over the table that does the CAST to 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.
...