You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2018/10/03 19:02:00 UTC

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

    [ https://issues.apache.org/jira/browse/HIVE-19844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16637386#comment-16637386 ] 

Naveen Gangam commented on HIVE-19844:
--------------------------------------

[~achinn1] Are you actively working on this? if not, may I re-assign this so we could bring this to a resolution? If you intend to work on it, could you please provide a timeframe when you might be able to get to this? Thanks

> 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
>            Assignee: anand
>            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 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)