[ https://issues.apache.org/jira/browse/HIVE-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Grover updated HIVE-3751: ------------------------------ Description: 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 was: 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: {{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=jgtyjoxp...@mail.gmail.com%3E > 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