Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

Hive Connection Timeout

avatar
Frequent Visitor

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

1 REPLY 1

avatar
Rising Star

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