drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2540) CSVReader : Drill not reading the last column from a text file if it is an empty string
Date Tue, 24 Mar 2015 18:06:52 GMT
Rahul Challapalli created DRILL-2540:
----------------------------------------

             Summary: CSVReader : Drill not reading the last column from a text file if it
is an empty string
                 Key: DRILL-2540
                 URL: https://issues.apache.org/jira/browse/DRILL-2540
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Text & CSV
            Reporter: Rahul Challapalli
            Assignee: Steven Phillips


git.commit.id.abbrev=f1b59ed

Data Set :
{code}
Hello|World
|
{code}

The below queries suggest that drill is treating columns[1] as a missing column for the second
record while it treats columns[0] as empty string for the second record
{code}
0: jdbc:drill:schema=dfs_eea> select * from `temp.tbl`;
+------------+
|  columns   |
+------------+
| ["Hello","World"] |
| [""]       |
+------------+
2 rows selected (0.098 seconds)
0: jdbc:drill:schema=dfs_eea> select columns[0] from `temp.tbl`;
+------------+
|   EXPR$0   |
+------------+
| Hello      |
|            |
+------------+
2 rows selected (0.103 seconds)
0: jdbc:drill:schema=dfs_eea> select columns[1] from `temp.tbl`;
+------------+
|   EXPR$0   |
+------------+
| World      |
| null       |
+------------+
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message