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

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

     [ https://issues.apache.org/jira/browse/DRILL-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Abhishek Girish closed DRILL-2018.
----------------------------------

Was resolved as duplicate. Closing. 

> Error message 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
>            Priority: Minor
>
> 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)