ERROR [HY000] [MapR][Drill] (1040)
Drill failed to execute the query:
select * from INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE '%' ESCAPE '\' AND SCHEMA_NAME <> 'sys' AND SCHEMA_NAME <> 'INFORMATION_SCHEMA'
Query execution error. Details:[
SYSTEM ERROR: IllegalStateException: state should be: open
[Error Id: 57a02508-1920-4360-a111-c2a55a7af15c on HOSTNAME:31010]
Apparently, this is related to a connection cache that expires at some point and is not reset. In this case, restarting the drillbit solves the problem. Once the patch from 21/07/15 is part of the build, this should not happen any more.