You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/04/24 22:11:40 UTC

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

Krystal created DRILL-2872:
------------------------------

             Summary: Result from json file returns data from map type fields as "null"
                 Key: DRILL-2872
                 URL: https://issues.apache.org/jira/browse/DRILL-2872
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - C++
            Reporter: Krystal
            Assignee: Parth Chandra


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.



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