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

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

Ramana Inukonda Nagaraj created DRILL-1344:
----------------------------------------------

             Summary: Nested json object null is treated as {}
                 Key: DRILL-1344
                 URL: https://issues.apache.org/jira/browse/DRILL-1344
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
            Reporter: Ramana Inukonda Nagaraj


With a json record as follows:

"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"}

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.2#6252)