Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4788

Exporting from Parquet to CSV - commas in strings are not escaped

    XMLWordPrintableJSON

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                patchfx Richard Patching
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: