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)
