[DRILL-5792] CONVERT_FROM_JSON on an empty file throws runtime exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Vitalii Diravka
• Reporter: Prasad Nagaraj Subramanya
• Created: 14/Sep/17 19:56
• Updated: 02/Oct/17 20:55
• Resolved: 02/Oct/17 20:55

Description

Sample query to reproduce-

SELECT CONVERT_FROM(columns[1], 'JSON') as col1 FROM dfs.`file1.tbl`;

Throws runtime exception-

Error: Unexpected RuntimeException: java.lang.UnsupportedOperationException: Unable to find sql accessor for minor type [NULL] and mode [OPTIONAL] (state=,code=0)

The expected result is that the query returns 0 rows.

Issue observed with commit id - 7a900b71fd269aceee7301afb18fd8d303df5bcd

Expected result-

+-------+
| col1  |
+-------+
+-------+

Works with drill 1.11.0

Issue Links

• links to: GitHub Pull Request #961