[ https://issues.apache.org/jira/browse/HIVE-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13690146#comment-13690146 ]
Kamil Chmielewski commented on HIVE-3751: ----------------------------------------- We can include http://dev.bizo.com/2010/11/csv-and-hive.html and start with it. > Handle enclosing characters in delimited fields > ----------------------------------------------- > > Key: HIVE-3751 > URL: https://issues.apache.org/jira/browse/HIVE-3751 > Project: Hive > Issue Type: New Feature > Components: Serializers/Deserializers > Affects Versions: 0.9.0 > Reporter: Mark Grover > > People have requested in the past to have Hive support enclosing characters > in delimited row format. > An example of such data: > {code} > "1", "123456", " ", "Charlotte, NC" > {code} > The format of the create table statement may look like: > {code} > DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY char] > [FIELDS ENCLOSED BY char] > {code} > 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=jgtyjoxp...@mail.gmail.com%3E -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira