AnsweredAssumed Answered

Unable to read .json file using Apche Drill

Question asked by 1004140 on Aug 30, 2016
Latest reply on Aug 31, 2016 by 1004140

I have this sample .json given below which has an array inside another array. I would like to read the elements of the inner array using Apache Drill ,i.e., the elements of fixVersions. Any help is appreciated.

 

Sample JSON:

 

{

  "expand": "schema,names",

  "startAt": 0,

  "maxResults": 1000,

  "total": 2,

  "issues": [

    {

      "id": "10001",

      "key": "CS-10001",

      "fields": {

        "field_100": "abc",

        "field_101": "kolkata",

        "fixVersions": [

          1.1,

          1.2

        ],

        "field_102": "india",

        "field_103": "378.0",

        "priority": {

          "name": "4-Medium",

          "id": "10008"

        }

      }

    },

    {

      "id": "10002",

      "key": "CS-10002",

      "fields": {

        "field_100": "def",

        "field_101": "delhi",

        "fixVersions": [

          1.1,

          1.2,

          1.3

        ],

        "field_102": "india",

        "field_103": "380.0",

        "priority": {

          "name": "5-High",

          "id": "10008"

        }

      }

    }   

  ]

}

Outcomes