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.