[DRILL-2872] Result from json file returns data from map type fields as "null"

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Execution - Data Types
• Assignee: Parth Chandra
• Reporter: Krystal
• Created: 24/Apr/15 20:11
• Updated: 04/May/15 16:28
• Resolved: 29/Apr/15 00:41

Description

git.commit.id=9ec257efb7992209e27c82e6f4ee8a5b12cc95e4

select from a json file from ODBC returns data for map fields as "null". For example:

select * from `dfs.drillTestDirJson`.`complex_student.json`
1 fred ovid 76 1.55 692315658449 2014-05-27 00:26:07 [ null, null, null ]

{ "color" : "Blue", "sport" : "Soccer", "food" : "Spaghetti" }

2 bob brown 63 3.18 650706039334 2014-12-04 21:43:14 [ null, null, null ]

{ "color" : "Green", "sport" : "Soccer", "food" : "Pizza" }

3 bob hernandez 28 1.09 293612255322 2014-05-31 14:33:06 [ null, null, null ]

{ "color" : "Red", "sport" : "Tennis", "food" : "Hamburger" }

4 ulysses xylophone 31 1.67 896547822355 2014-06-12 11:27:33 [ null, null, null ]

{ "color" : "Yellow", "sport" : "Hockey", "food" : "Pizza" }

sqlline returns correct data for the same query.