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)
