[jira] [Created] (DRILL-2018) Error messages must be updated when Drill fails to handle JSON files with mutating schemas within fields.

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2018:
--------------------------------------

             Summary: Error messages must be updated when Drill fails to handle JSON files with mutating schemas within fields.
                 Key: DRILL-2018
                 URL: https://issues.apache.org/jira/browse/DRILL-2018
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
            Reporter: Abhishek Girish
            Assignee: Jacques Nadeau


Currently Drill fails to read JSON files with the following structure:

Below is the snippet causing the issue: 

{
  "data": {
    "games": {
      "game": [
        {
          "home_runs": {
            "player": {
              "first": "Jason"
            }
          }
        },
        {
          "home_runs": {
            "player": [
              {
                "first": "Kosuke"
              },
              {
                "first": "Alfonso"
              },
              {
                "first": "Jeff"
              },
              {
                "first": "Brandon"
              }
            ]
          }
        }
      ]
    }
  }
}

> select * from `snippet.json` limit 1;

Query failed: Query stopped., You tried to write a Map type when you are using a ValueWriter of type SingleMapWriter. [ 358d955b-d834-476c-b649-95059c264030 on abhi5.qa.lab:31010 ]

Error: exception while executing query: Failure while executing query. (state=,code=0)

The error message must be updated to indicate clearly that this feature is not currently not supported. It would also be helpful if the fields having the issue is also indicated, as it would help narrow down the issue. 



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