Beeline and Hive connectivity causes connection reset error

TalendSolutionExpert — Fri, 09 Feb 2024 18:22:49 GMT

Problem Description

Beeline and Hive connectivity causes a connection reset error in Studio logs.

There are two possible solutions:

Configure timeout length for client and server:
1. Client-side configuration:
  
  In your Job, change the timeout length for the client-side configuration by adding the following parameter to your Hive connection:
```
hive.metastore.client.socket.timeout
```
  This is measured in seconds, and should be set to a value longer than the duration of each individual Hive connection query. 60 minutes is a good starting point.
2. Server-side configurations:
```
hive.server.thrift.socket.timeout=1000
hive.client.thrift.socket.timeout=1000
```
If the resolution above does not work, perform the following steps:
1. Back up the Hive database.
2. Remove Hive from the node.
3. Add a new node and install Hive.
4. Restore the Hive database.