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

Handle enclosing characters in delimited fields

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.9.0
    • None
    • None

    Description

      People have requested in the past to have Hive support enclosing characters in delimited row format.

      An example of such data:

      "1", "123456", " ", "Charlotte, NC" 
      

      The format of the create table statement may look like:

      DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY char] [FIELDS ENCLOSED BY char]
      

      The first pass solution to this JIRA may disallow inclusion of enclosing characters within the data. A latter improvement could be to allow escaping of enclosing characters within the data.

      Reference mailing list thread:
      http://mail-archives.apache.org/mod_mbox/hive-user/201204.mbox/%3CCAENxBwwrZrqBSJXtJHpqc_FfcZvwRMoaT9W7dR=JGtYJoXPqLw@mail.gmail.com%3E

      Attachments

        Activity

          People

            xuefuz Xuefu Zhang
            mgrover Mark Grover
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: