Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19844

Make CSV SerDe First-Class SerDe

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0, 2.3.2, 4.0.0
    • Fix Version/s: None
    • Labels:
      None

      Description

      According to the Hive SerDe Docs, there are some extras steps involved in getting the CSV SerDe working with Hive.

      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;
      

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                belugabehr David Mollitor
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: