[IMPALA-1942] JDBC queries stay "in flight" as FINISHED instead of getting archived

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: Impala 2.1.2
• Labels: jdbc query-lifecycle
• Environment: impalad version 2.1.2-cdh5 RELEASE (build 92438b7fb62a875041ffd2ab324f408ecf8129e5)
• Target Version: Impala 2.3.0
• Assignee: Unassigned
• Reporter: Alexandre Pastorino
• Created: 07/Apr/15 14:27
• Updated: 20/Dec/15 00:05
• Resolved: 14/Jul/15 18:52

Description

Hi everyone,

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

Additional information:
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?

Regards.