[ 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)