[DRILL-5555] CSV file without headers: "SELECT a" fails, "SELECT columns, a" succeeds

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Storage - Text & CSV
• Assignee: Unassigned
• Reporter: Paul Rogers
• Created: 29/May/17 23:47
• Updated: 21/May/19 15:35

Description

Consider the case discussed in DRILL-5554. Do exactly the same setup, but with a slightly different query. The results are much different.

Create a CSV file without headers:

10,foo,bar

Use a CSV storage plugin configured to not skip the first line and not read headers.

Then, issue the following query:

SELECT columns, a FROM `dfs.data.example.csv`

Result:

columns,a
["10","foo","bar"],null

Schema:

columns(VARCHAR:REPEATED), 
a(INT:OPTIONAL)

Since the query in DRILL-5554 fails:

SELECT a FROM ...

Expected the query described here to also fail, for a similar reason.