You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/04/23 19:30:40 UTC

[jira] [Closed] (DRILL-950) Incorrect parsing of CSV files

     [ https://issues.apache.org/jira/browse/DRILL-950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krystal closed DRILL-950.
-------------------------

Verified that bug is fixed.  Test added to private-sql-hadoop-test/framework/resources/Functional/Passing/text_storage/testcases/drill950.q

> Incorrect parsing of CSV files
> ------------------------------
>
>                 Key: DRILL-950
>                 URL: https://issues.apache.org/jira/browse/DRILL-950
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Text & CSV
>    Affects Versions: m1
>            Reporter: Tomer Shiran
>            Assignee: Jacques Nadeau
>             Fix For: 0.4.0
>
>         Attachments: DRILL-950.patch
>
>
> CSV parsing is incorrect. Commas inside quotes should be part of the string and not delimiters. Example:
> 140210850,"SEX OFFENSES, FORCIBLE","FORCIBLE RAPE, BODILY FORCE",Thursday,03/06/2014,19:15,NORTHERN,NONE,1200 Block of FRANCISCO ST,-122.425463608081,37.8031020597099,"(37.8031020597099, -122.425463608081)"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)