Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1942

JDBC queries stay "in flight" as FINISHED instead of getting archived

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Not A Bug
    • Affects Version/s: Impala 2.1.2
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      impalad version 2.1.2-cdh5 RELEASE (build 92438b7fb62a875041ffd2ab324f408ecf8129e5)

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              apastorino_impala_5832 Alexandre Pastorino
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: