[ 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)