You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2017/07/24 15:42:00 UTC

[jira] [Created] (DRILL-5684) Add documentation for lineDelimiter

Abhishek Girish created DRILL-5684:
--------------------------------------

             Summary: Add documentation for lineDelimiter
                 Key: DRILL-5684
                 URL: https://issues.apache.org/jira/browse/DRILL-5684
             Project: Apache Drill
          Issue Type: Task
          Components: Documentation
    Affects Versions: 1.10.0, 1.11.0
            Reporter: Abhishek Girish
            Assignee: Bridget Bevens


We need to document the lineDelimiter attribute in [1], [2]. Also possibly a note that if using Drill on Windows, the new line delimiter in text files can be different from that on Linux / Mac. If the delimited text data has \r\n as the lineDelimiter (carriage return & new line) and querying it from Drill doesn't work as expected, we need to update the format plugin, as shown in the example below:
{code}
"csv": {
      "type": "text",
      "extensions": [
        "csv"
      ],
      "lineDelimiter": "\r\n",
      "extractHeader": true,
      "delimiter": ","
    }
{code}

[1] https://drill.apache.org/docs/plugin-configuration-basics/#list-of-attributes-and-definitions
[2] https://drill.apache.org/docs/text-files-csv-tsv-psv/#configuring-drill-to-read-text-files




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)