Impala jdbc connection drops intermittently

[#1]

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 

[#2]

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

[#3]

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

[#4]

@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...