Products | Versions |
---|---|
TIBCO Data Virtualization | All Supported Versions |
The error message "java.net.SocketException: Broken pipe (Write failed)" in a Java application typically indicates that the connection to a remote server was lost unexpectedly. The socket exceptions usually occur at the network layer when there is an error while accessing or writing to sockets. (java.net.SocketException).
To resolve this, add the IDLE_SESSION_TIMEOUT property in the JDBC Connection properties for the Impala data source.
Steps to add the property:
1. In the studio, open the Impala data source.
2. In the Advanced tab, click on 'JDBC Connection Properties'.
3. Add the Idle_Session_Timeout property and value. Ideally, the value should match with the value on the physical Impala database.
Refer to the below article to learn more about the property:
https://impala.apache.org/docs/build/html/topics/impala_idle_session_timeout.html