Is this by design or is this a bug ?
On Tue, Nov 8, 2016 at 2:13 PM, Khurram Faraaz <[email protected]> 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
>
