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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 1.0.0
• Component/s: Execution - Data Types, Execution - Flow
• Assignee: Parth Chandra
• Reporter: Krystal
• Created: 09/Dec/14 18:51
• Updated: 01/May/15 23:15
• Resolved: 27/Apr/15 18:18

Description

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 ]