Prasad Nagaraj Subramanya created DRILL-5792:
------------------------------------------------
Summary: CONVERT_FROM_JSON on an empty file throws runtime
exception
Key: DRILL-5792
URL: https://issues.apache.org/jira/browse/DRILL-5792
Project: Apache Drill
Issue Type: Bug
Reporter: Prasad Nagaraj Subramanya
Sample query to reproduce-
{code}
SELECT CONVERT_FROM(columns[1], 'JSON') as col1 FROM dfs.`file1.tbl`;
{code}
Throws runtime exception-
{code}
Error: Unexpected RuntimeException: java.lang.UnsupportedOperationException:
Unable to find sql accessor for minor type [NULL] and mode [OPTIONAL]
(state=,code=0)
{code}
The expected result is that the query returns 0 rows.
Issue observed with commit id - 7a900b71fd269aceee7301afb18fd8d303df5bcd
Expected result-
{code}
+-------+
| col1 |
+-------+
+-------+
{code}
Works with drill 1.11.0
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)