[HIVE-3751] Handle enclosing characters in delimited fields

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: Serializers/Deserializers
• Assignee: Xuefu Zhang
• Reporter: Mark Grover
• Created: 28/Nov/12 16:10
• Updated: 13/Aug/13 15:20

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=[e-mail]%3E