[jira] [Updated] (DRILL-1832) Select * from json file failed with java.lang.IllegalArgumentException: null

["Parth Chandra (JIRA)" <ji...@apache.org>]

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

Parth Chandra updated DRILL-1832:
---------------------------------
    Fix Version/s:     (was: 0.9.0)
                   1.0.0

> Select * from json file failed with java.lang.IllegalArgumentException: null
> ----------------------------------------------------------------------------
>
>                 Key: DRILL-1832
>                 URL: https://issues.apache.org/jira/browse/DRILL-1832
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types, Execution - Flow
>    Affects Versions: 0.7.0
>            Reporter: Krystal
>            Assignee: Parth Chandra
>             Fix For: 1.0.0
>
>         Attachments: drill-1832.log, twitter_43.json
>
>
> git.commit.id.abbrev=201280e
> I have a json file that contains nested data.  When I do a "select *" , the query failed as follows:
> 0: jdbc:drill:schema=dfs.root> select * from `./json/twitter_43.json`;
> Query failed: Query stopped.[ cc231dec-8d28-4532-a938-c5f67592f262 on qa-node114.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> Also, the following select fails:
> 0: jdbc:drill:schema=dfs.root> select SUM(1) as `sum_Number_of_Records_ok` from `./json/twitter_43.json` having (COUNT(1) > 0);
> 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. [ 364d911a-3bc8-4042-b5a2-6ed074c999ce on qa-node114.qa.lab:31010 ]
> [ 364d911a-3bc8-4042-b5a2-6ed074c999ce on qa-node114.qa.lab:31010 ]



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