drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2018) Error messages must be updated when Drill fails to handle JSON files with mutating schemas within fields.
Date Thu, 15 Jan 2015 23:25:34 GMT
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)

Mime
View raw message