drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Faraaz <kfar...@maprtech.com>
Subject Query JSON that has null as value for each key
Date Tue, 08 Nov 2016 08:43:00 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message