[jira] [Commented] (HIVE-3751) Handle enclosing characters in delimited fields
[ https://issues.apache.org/jira/browse/HIVE-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13738348#comment-13738348 ] Xuefu Zhang commented on HIVE-3751: --- I plan to work on this. However, if anyone else wants it, please feel free. 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 Assignee: Xuefu Zhang 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
[jira] [Commented] (HIVE-3751) Handle enclosing characters in delimited fields
[ https://issues.apache.org/jira/browse/HIVE-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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