[DRILL-2018] Error message must be updated when Drill fails to handle JSON files with mutating schemas within fields.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: Storage - JSON
• Assignee: Jacques Nadeau
• Reporter: Abhishek Girish
• Created: 15/Jan/15 23:25
• Updated: 24/Apr/15 22:40
• Resolved: 15/Jan/15 23:45

Description

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.

Issue Links

• duplicates: DRILL-1728 Better error messages on Drill JSON read error