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)
