[DRILL-5033] Query on JSON that has null as value for each key

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.9.0
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: Khurram Faraaz
• Created: 10/Nov/16 19:02
• Updated: 18/Jan/23 00:54

Description

Drill 1.9.0 git commit ID : 83513daf

Drill returns same result with or without `store.json.all_text_mode`=true

Note that each key in the JSON has null as its value.
[root@cent01 null_eq_joins]# cat right_all_nulls.json
{
"intKey" : null,
"bgintKey": null,
"strKey": null,
"boolKey": null,
"fltKey": null,
"dblKey": null,
"timKey": null,
"dtKey": null,
"tmstmpKey": null,
"intrvldyKey": null,
"intrvlyrKey": null
}
[root@cent01 null_eq_joins]#

Querying the above JSON file results in null as query result.

• We should see each of the keys in the JSON as a column in query result.
• And in each column the value should be a null value.
  Current behavior does not look right.

0: jdbc:drill:schema=dfs.tmp> select * from `right_all_nulls.json`;
+-------+
|   *   |
+-------+
| null  |
+-------+
1 row selected (0.313 seconds)

Adding comment from Julian Hyde

IMHO it is similar but not the same as DRILL-1256. Worth logging an issue and let Jacques Nadeau (or someone) put on the record what should be the behavior of an empty record (empty JSON map) when it is top-level (as in this case) or in a collection.

Issue Links

• is related to: DRILL-4842 SELECT * on JSON data results in NumberFormatException
• is related to: DRILL-4824 Null maps / lists and non-provided state support for JSON fields. Numeric types promotion.