Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2872

Result from json file returns data from map type fields as "null"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 1.0.0
    • Execution - Data Types
    • None

    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.

      Attachments

        1. complex_student.json
          2 kB
          Parth Chandra
        2. DRILL-2872.patch.diff
          6 kB
          Parth Chandra

        Activity

          People

            parthc Parth Chandra
            knguyen Krystal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: