[jira] [Commented] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

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

Deneche A. Hakim commented on DRILL-1891:
-----------------------------------------

This was fixed by DRILL-2675. Here is the error message I get when running the 2nd query:
{noformat}
0: jdbc:drill:zk=local> select a1 from dfs.tmp.`test.json` where a1 is not null group by a1;
Query failed: DATA_READ ERROR: Error parsing JSON. - Unexpected character (':' (code 58)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

Filename /tmp/test.json
Record 4
Column 9
Fragment 0:0

[d502c2a9-34f8-4363-a6a3-ed1a3151dd71 on abdel-11.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{noformat}

> Error message does not get propagated correctly when reading from JSON file
> ---------------------------------------------------------------------------
>
>                 Key: DRILL-1891
>                 URL: https://issues.apache.org/jira/browse/DRILL-1891
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>    Affects Versions: 0.7.0
>            Reporter: Victoria Markman
>            Assignee: Deneche A. Hakim
>             Fix For: 1.0.0
>
>
> I made a mistake in t.json file (extra colon in the last row):
> {code}
> { "a1": 0 , "b1": "a"}
> { "a1": 1 , "b1": "b"}
> { "a1": 2 , "b1": "c"}
> { "a1":: 3 , "b1": "c"}
> {code}
> Error message below pretty much tells me everything that went wrong.
> {code}
> 0: jdbc:drill:schema=dfs> select a1 from `t.json` where a1 is not null;
> Query failed: Query stopped., Unexpected character (':' (code 58)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
>  at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede; line: 3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on atsqa4-133.qa.lab:31010 ]
> {code}
> However, if a result of query above is an input to any other operator, I get this error message:
> {code}
> 0: jdbc:drill:schema=dfs> select a1 from `t.json` where a1 is not null group by a1;
> Query failed: Query failed: Failure while running fragment., You tried to do a batch data read operation when you were in a state of STOP.  You can only do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
> [ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> Very painful for the user if query is really complex.
> The same behavior if file does not exist.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)