You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "BELUGA BEHR (JIRA)" <ji...@apache.org> on 2019/03/01 21:17:00 UTC
[jira] [Updated] (HIVE-19844) Make CSV SerDe First-Class SerDe

     [ https://issues.apache.org/jira/browse/HIVE-19844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

BELUGA BEHR updated HIVE-19844:
-------------------------------
    Description: 
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 CSVFILE}}
{{STORED AS TSVFILE}}

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

  was:
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.


> 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: 3.0.0, 2.3.2, 4.0.0
>            Reporter: BELUGA BEHR
>            Priority: Major
>
> 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 CSVFILE}}
> {{STORED AS TSVFILE}}
> The user should have to perform no additional steps to use this SerDe.



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