Support Questions

Find answers, ask questions, and share your expertise

Impala jdbc connection drops intermittently

avatar
Rising Star

Connecting to impala using one of the BI tools with jdbc string on port 21050

The connection is successful but drops intermittently for some time with below error

java.net.SocketException: Connection or outbound has closed

The firewall is open, there is no network issue between two servers 

3 REPLIES 3

avatar
Expert Contributor

Please check if you are using impala LB for the connection string or impala daemon.

avatar
Rising Star

yes there is impala daemon used in connection string, how to tackle this error if it is caused due to daemon in connection string 

avatar
Contributor

@hadoopranger  Consider tuning parameters like idle_session_timeout and idle_query_timeout which is suspected to be closing the session considering you don't have LB in place.

You can also set it to 0 where session will never expire until closed manually.

Moreover, consider increasing value of fe_service_threads to allow more concurrent client connections which should help you avoiding similar client connection issue in future.

For more info, refer: https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/impala-reference/topics/impala-recommended-co...