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

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Cannot Reproduce
• Component/s: Clients
• Flags: Important
• Epic Color: ghx-label-13
• Assignee: Tim Armstrong
• Reporter: jayashree
• Created: 31/Jul/20 10:27
• Updated: 11/Feb/21 18:30
• Resolved: 11/Feb/21 18:30

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

• is duplicated by: IMPALA-10031 Unable to close the connection when fetching data from two databases