THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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 | ||
|---|---|---|
| ||
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.
...