[
https://issues.apache.org/jira/browse/DRILL-3726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341825#comment-15341825
]
Arina Ielchiieva commented on DRILL-3726:
-----------------------------------------
User will have two options:
1. specify delimiter in select clause:
select * from table(dfs.`my_table`(type=>'text', 'lineDelimiter'=>'\r\n'))
2. update storage plugin lineDelimiter value to '\r\n' on web UI.
> Drill is not properly interpreting CRLF (0d0a). CR gets read as content.
> ------------------------------------------------------------------------
>
> Key: DRILL-3726
> URL: https://issues.apache.org/jira/browse/DRILL-3726
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Text & CSV
> Affects Versions: 1.1.0
> Environment: Linux RHEL 6.6, OSX 10.9
> Reporter: Edmon Begoli
> Fix For: 1.7.0
>
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> When we query the last attribute of a text file, we get missing characters.
> Looking at the row through Drill, a \r is included at the end of the last
> attribute.
> Looking in a text editor, it's not embedded into that attribute.
> I'm thinking that Drill is not interpreting CRLF (0d0a) as a new line, only
> the LF, resulting in the CR becoming part of the last attribute.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
