My Impala queries launched through jdbcTemplate.query() always stay "in flight" despite being marked as "FINISHED" in the "/queries" view (http://prntscr.com/6qpxc4).
Our cluster administrator says this is causing a resource leak (but he could be mistaken).
Those queries are marked as "executing" in the Impala management console, even though they returned the complete results. Only when cancelled using the link in the screenshot, the Impala management console shows the queries as finished.
Here is the debug logging from the JDBC:
2015-04-07 15:45:31,687 DEBUG [JdbcTemplate] Executing prepared SQL query
2015-04-07 15:45:31,688 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT something FROM some.table LIMIT 25]
2015-04-07 15:45:31,688 DEBUG [DataSourceUtils] Fetching JDBC Connection from DataSource
2015-04-07 15:45:32,001 DEBUG [DataSourceUtils] Returning JDBC Connection to DataSource
I am using the Spring Framework, so opening and closing the connection is done automatically.
I noticed I was using hive-jdbc-0.10.0-cdh4.2.0.jar as a connector. Would using a more recent one fix the problem?