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

Make CSV SerDe First-Class SerDe

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.3.2, 3.0.0, 4.0.0
    • None
    • 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

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

              Dates

                Created:
                Updated: