Hive Connection Timeout

Er_Omprakash — Wed, 01 Feb 2023 19:25:46 GMT

User trying to connect via beeline but connection itself taking long time. Please suugest what is the issue.

Re: Hive Connection Timeout

tarak271 — Mon, 24 Apr 2023 13:00:32 GMT

Please check

the number of open connections for each HiveServer2/HiveMetastore instance from CM UI to see if HS2/HMS instances are overloaded with high number of client connections
if HMS backend database is performing optimally or not
the performance of KDC or AD server if authentication is enabled
if there are high JVM pauses in CM charts of HS2/HMS or look for traces matching
```
Detected pause in JVM or host machine (eg GC)
```
If there is no abnormality in any of the above cases, then we might need to collect jstack for all the three processes i.e beeline, HS2 and HMS to confirm the location of slowness due to which connection is getting hung