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

Impala JDBC41 2.5.28 with connection pool -- "show tables" DDL not completing

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • Impala 2.0
    • None
    • Clients
    • CDH 5.4.7, Impala JDBC41 driver 2.5.28.1047

    Description

      Hi,

      We have a web services application that uses Hikari to maintain a connection pool of up to 10 Impala JDBC connections. The data source class configured is com.cloudera.impala.jdbc41.DataSource

      The issue we have is that Cloudera Manager often shows many "show tables" DDL's executing, and not completing.

      A look at the driver code shows the ImpalaJDBC41Connection class will execute the "show tables" DDL for connection validation. It looks like this class does not close the JDBC statement used to run "show tables". Shouldn't it close the statement?

      Thanks,
      James

      Attachments

        1. CDH - impala queries.png
          69 kB
          James Thomas
        2. impala-log.zip
          120 kB
          James Thomas
        3. TestImpalaJDBC.java
          2 kB
          James Thomas

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            shashmi Syed A. Hashmi
            james.thomas@siemens.com_impala_8ec2 James Thomas
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment