[IMPALA-2772] Impala JDBC41 2.5.28 with connection pool -- "show tables" DDL not completing

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Component/s: Clients
• Labels: impala jdbc
• Environment: CDH 5.4.7, Impala JDBC41 driver 2.5.28.1047
• Target Version: Impala 2.0
• Assignee: Syed A. Hashmi
• Reporter: James Thomas
• Created: 15/Dec/15 14:30
• Updated: 01/Feb/16 00:47
• Resolved: 01/Feb/16 00:47

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