[DRILL-2540] CSVReader : Drill not reading the last column from a text file if it is an empty string

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Storage - Text & CSV
• Assignee: Paul Rogers
• Reporter: Rahul Kumar Challapalli
• Created: 24/Mar/15 18:06
• Updated: 19/Jun/17 00:36

Description

git.commit.id.abbrev=f1b59ed

Data Set :

Hello|World
|

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

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       |
+------------+