Hi All,
Drill 1.9.0 git commit ID : 83513daf
Drill returns same result with or without `store.json.all_text_mode`=true
[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.
{noformat}
0: jdbc:drill:schema=dfs.tmp> select * from `right_all_nulls.json`;
+-------+
| * |
+-------+
| null |
+-------+
1 row selected (0.313 seconds)
{noformat}
Thanks,
Khurram