You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "nicolas paris (JIRA)" <ji...@apache.org> on 2018/11/14 21:32:00 UTC

[jira] [Created] (HIVE-20917) OpenCSVSerde quotes all columns

nicolas paris created HIVE-20917:
------------------------------------

             Summary: OpenCSVSerde quotes all columns
                 Key: HIVE-20917
                 URL: https://issues.apache.org/jira/browse/HIVE-20917
             Project: Hive
          Issue Type: Improvement
          Components: Serializers/Deserializers
            Reporter: nicolas paris


The OpenCSVSerde produces a CSV with all its columns quoted 

no matter of they type or if the string columns contain a separator or not.

 

The problem is some readers (such postgresql) are not compatible with

such CSV, in particular when bulk loading them thought COPY statement.

 

I propose a new CsvSerde, based on a Univocity Parser (wich is used by Apache Spark)

that has been described a 2 times faster thant OpenCSV. [https://github.com/uniVocity/csv-parsers-comparison] . This new CsvSerde whould only quote columns when needed.

 

Regards,



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)