[DRILL-1344] Nested json object null is treated as {}

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: Ramana Inukonda Nagaraj
• Created: 26/Aug/14 19:45
• Updated: 19/Jun/17 00:08

Description

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.

Issue Links

• is related to: DRILL-4824 Null maps / lists and non-provided state support for JSON fields. Numeric types promotion.