[jira] [Created] (HIVE-19844) Make CSV SerDe First-Class SerDe

["BELUGA BEHR (JIRA)" <ji...@apache.org>]

BELUGA BEHR created HIVE-19844:
----------------------------------

             Summary: Make CSV SerDe First-Class SerDe
                 Key: HIVE-19844
                 URL: https://issues.apache.org/jira/browse/HIVE-19844
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2, Serializers/Deserializers
    Affects Versions: 2.3.2, 3.0.0, 4.0.0
            Reporter: BELUGA BEHR


According to the [Hive SerDe Docs|https://cwiki.apache.org/confluence/display/Hive/CSV+Serde], there are some extras steps involved in getting the CSV SerDe working with Hive.

{code}
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;
{code}

I would like to propose that we move this SerDe into first-class status:

{{STORED AS TEXT_CSV}}
{{STORED AS TEXT_TSV}}

The user should have to perform no additional steps to use this SerDe.



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