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