Skip to main content
hadoopranger
hadoopranger
Gold ⭐️⭐️
August 7, 2024
Question

Impala jdbc connection drops intermittently

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

AyazHussain
Gold ⭐️⭐️⭐️
AyazHussain
Gold ⭐️⭐️⭐️
August 8, 2024

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

Translate
    hadoopranger
    hadooprangerAuthor
    Gold ⭐️⭐️
    August 8, 2024

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

    Translate
    kbanik
    Silver ⭐️⭐️
    kbanik
    Silver ⭐️⭐️
    November 20, 2024

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

    Translate
    Terms & ConditionsAccessibility statement