[IMPALA-10031] Unable to close the connection when fetching data from two databases

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Component/s: Clients
• Epic Color: ghx-label-14
• Assignee: Unassigned
• Reporter: jayashree
• Created: 31/Jul/20 09:05
• Updated: 31/Jul/20 15:33
• Resolved: 31/Jul/20 15:33

Description

Hi Team,

I am connecting two databases using cloudera.impala.jdbc41.Driver.

I have two classes with two different connections, each having different SQLs to perform in respective database.

When I am executing these two classes together, I am getting below error though I am closing first connection and then connecting to other Database.

Error: 

j*ava.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Could not resolve table reference:* 
Caused by: java.sql.SQLException:
[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Could not resolve table reference: 
Caused by: com.cloudera.support.exceptions.GeneralException:
[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Could not resolve table reference: 

 

Seems its not able to close first connection.

Can you please check it

Issue Links

• duplicates: IMPALA-10032 Unable to close the connection when fetching data from two databases