drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Faraaz <kfar...@maprtech.com>
Subject Re: Query JSON that has null as value for each key
Date Wed, 09 Nov 2016 18:20:36 GMT
Is this by design or is this a bug ?

On Tue, Nov 8, 2016 at 2:13 PM, Khurram Faraaz <kfaraaz@maprtech.com> wrote:

> 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