Julian Hyde created DRILL-1241:
----------------------------------
Summary: Query that returns 0 rows gives alarming error
Key: DRILL-1241
URL: https://issues.apache.org/jira/browse/DRILL-1241
Project: Apache Drill
Issue Type: Bug
Reporter: Julian Hyde
When I run a query with 'limit 0' I got an error that sounded like an internal
protocol error.
{code:sql}
0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` limit 0;
Query failed: Failure while running fragment. The incoming iterator returned a
state of NONE on the first batch. There should always be at least one batch
output before returning NONE [a7416ee7-1d9c-4591-a927-2664455f3ef1]
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)
{code}
Should be more like a user error, since Drill cannot handle queries that return
0 rows. Or maybe (if as I surmise the problem is that Drill just doesn't know
the names of the columns) generate a default column 'unknown_result_set_schema'
and no rows.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
