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

Posted to issues@drill.apache.org by "Richard Patching (JIRA)" <ji...@apache.org> on 2016/07/19 07:33:20 UTC

[jira] [Created] (DRILL-4788) Exporting from Parquet to CSV - commas in strings are not escaped

Richard Patching created DRILL-4788:
---------------------------------------

             Summary: Exporting from Parquet to CSV - commas in strings are not escaped
                 Key: DRILL-4788
                 URL: https://issues.apache.org/jira/browse/DRILL-4788
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.6.0
         Environment: Linux
            Reporter: Richard Patching


When exporting data from Parquet to CSV, if there is a column which contains a comma, the text after the comma gets put into the next column instead of being escaped.

The only work around is to do REGEXP_REPLACE(COLUMN[0], ',',' ') which replaced the comma in the string with a blank space. This is not ideal in terms of keeping a true accurate record of the data we receive.



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