question Re: impala connection issue in Support Questions

impala connection issue

luffy07 — Thu, 14 Nov 2024 08:05:25 GMT

Hi all,

Am new to Hadoop, so while working i found this alert where the users getting this error intermittently. As i have checked logs it says due to memory issue job not able to run but when i checked memory its not full.

What is the solution for this?

We are facing impala connectivity issue.

[ERROR] 2024-11-14 05:32:42,548 com.tcl.move.dao.JDBCConnection - Exception Occurred while creating a connection java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500605) Error occurred while opening a session with the server. No additional detail from the server regarding this error is available. Please ensure that the driver configuration is compatible with the server configuration. This type of error can also occur when the server is too busy to handle the request. Please try again later.

Re: impala connection issue

VidyaSargur — Fri, 15 Nov 2024 04:52:44 GMT

@luffy07, Welcome to our community! To help you get the best possible answer, I have tagged our Impala experts @ChethanYM who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: impala connection issue

ChethanYM — Fri, 15 Nov 2024 09:55:26 GMT

@luffy07 The given error message is generic when you are using JDBC driver to connect impala and it does not suggest the specific cause.

Verify your Impala JDBC connection string is correct, port and Hosts are reachable etc..

Check Impala server that you are trying to connect is up and running fine, paste the memory errors here to understand what you are seeing in the logs.

Also you can append the below into JDBC connection string and repro the issue , It will generate driver DEBUG logs and may give some more details about the issue.

LogLevel=6;LogPath=/tmp/jdbclog

And try to use the latest Impala JDBC driver that is avaible.

https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-34.html

Regards,

Chethan YM