[DRILL-5534] convert_from on a json map with null value produces an NPE

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 23/May/17 17:32
• Updated: 24/May/17 10:08

Description

git.commit.id.abbrev=d11aba2

The below query fails with an NPE. Surprisingly there is information about the error in the logs

0: jdbc:drill:zk=10.10.100.190:5181> select convert_from('{kpi : null}' ,'json') as kpi from cp.`tpch/lineitem.parquet` limit 1;
Error: Unexpected RuntimeException: java.lang.NullPointerException (state=,code=0)

Adding one more column to the above query gets rid of the NPE

select '' as rk, convert_from('{kpi : null}' ,'json') as kpi from cp.`tpch/lineitem.parquet` limit 1;
+-----+------+
| rk  | kpi  |
+-----+------+
|     | {}   |
+-----+------+
1 row selected (1.013 seconds)

Issue Links

• is related to: DRILL-4824 Null maps / lists and non-provided state support for JSON fields. Numeric types promotion.