You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Christopher Matta <cm...@mapr.com> on 2015/01/02 22:01:38 UTC

Query failed: You tried to do a batch data read operation when you were in a state of STOP.

I got this error while trying to load a drill view of twitter data in
Tableau.

This is the query Tableau is running (run in sqlline to get this error):

1/1          SELECT SUM(1) AS `sum_Number_of_Records_ok`
FROM `mfs.views`.`twitter_tweets` `twitter_tweets`
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. [ 9f44521b-4b59-49b3-b231-8af54e865ca3 on
ip-172-16-1-174:31010 ]
[ 9f44521b-4b59-49b3-b231-8af54e865ca3 on ip-172-16-1-174:31010 ]

Error: exception while executing query: Failure while executing query.
(state=,code=0)
Aborting command set because "force" is false and command failed:
"SELECT SUM(1) AS `sum_Number_of_Records_ok`
FROM `mfs.views`.`twitter_tweets` `twitter_tweets`
HAVING (COUNT(1) > 0);"
Closing: org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection

Does anyone know what this means? I have more logs if anyone is interested.

Chris Matta
cmatta@mapr.com
215-701-3146
​