[jira] [Commented] (DRILL-1243) Drill's error message not clear when it fails reading json files containing arrays of hetrogeneous types

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

    [ https://issues.apache.org/jira/browse/DRILL-1243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16780161#comment-16780161 ] 

Abhishek Girish commented on DRILL-1243:
----------------------------------------

I think the error is better now. Closing. {code}
> select * from dfs.`/Users/agirish/het.json`;
Error: UNSUPPORTED_OPERATION ERROR: In a list of type FLOAT8, encountered a value of type BIGINT. Drill does not support lists of different types.

Line 1
Column 27
Field coordinates
Fragment 0:0
{code}

> Drill's error message not clear when it fails reading json files containing arrays of hetrogeneous types
> --------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1243
>                 URL: https://issues.apache.org/jira/browse/DRILL-1243
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Priority: Minor
>             Fix For: Future
>
>
> git.commit.id.abbrev=98b208e
> Below is a simple json record which contains arrays holding different types of values
> {code}
> {"coordinates": [168.01,5]}
> {code}
> Query :
> {code}
> select * from `repeated_hetrogeneous_types.json`;
> Query failed: Screen received stop request sent. Needed to be in state INIT or IN_BIGINT but in mode IN_FLOAT8
> {code}
> When I tried adding a string to the above json array, the error message from sqlline was even wierder.
> Manually debugging this is challenging as we have to nail it down to the specific record which is failing



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)