Hi all,

I'm trying to do a really simple query on a parquet directory on HDFS.

This works fine:

select count(*) from hdfs.warehouse.saleparquet

However, this fails:

0: jdbc:drill:local> select sum(sellprice) from hdfs.warehouse.saleparquet;
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. [ 92fc8807-220b-466c-bbac-1f524d4251cb on
ip-10-8-1-154.ap-southeast-2.compute.internal:31010 ]
[ 92fc8807-220b-466c-bbac-1f524d4251cb on
ip-10-8-1-154.ap-southeast-2.compute.internal:31010 ]


Error: exception while executing query: Failure while executing query.
(state=,code=0)

Seems like a very simple query.

Funnily enough, if I copy it off HDFS to the local system and run the same
query against the local file, it works fine.  Just purely something to do
with HDFS.

Any ideas?  I'm running 0.7.

Reply via email to