[jira] [Updated] (DRILL-1344) Nested json object null is treated as {}

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-1344:
----------------------------------
    Issue Type: Improvement  (was: Bug)

> Nested json object null is treated as {}
> ----------------------------------------
>
>                 Key: DRILL-1344
>                 URL: https://issues.apache.org/jira/browse/DRILL-1344
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - JSON
>            Reporter: Ramana Inukonda Nagaraj
>             Fix For: Future
>
>
> With a json record as follows:
> {code}
> "trans_id":9,"date":null,"time":"20:16:13","user_info":null,"marketing_info":{"camp_id":2,"keywords":null},"trans_info":{"prod_id":[85,546,247,530,73,111,1,488,100,100,3,476,503,312],"purch_flag":"false"}
> {code}
> select date from the json results in a correct value as null.
> select user_info though results in {}
> Similarly 
> select marketing_info results in
> {"camp_id":2,"keywords":[]}
> Correct behavior should be to return null for null complex types and null for members of complex types.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)