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)

Reply via email to