Support Questions

Find answers, ask questions, and share your expertise

HiveServer2 often has internal pauses

avatar
New Contributor

Hi
    For example, the hive component of cluster CDH often has internal pause. How to tune it?
    CDH version : CDH 6.3.2

5 REPLIES 5

avatar
Community Manager

@uinn Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Hive experts @cravani @james_jones  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
New Contributor

Thank you, but my problem hasn't been solved yet


avatar
Community Manager

@PranavM @mszurap Hi! Do you have any insights here? Thanks!


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
Super Collaborator

Could you please provide a brief explanation of the issue?

Is there a query stuck in Hive? If so, could you share the query details and specify whether it gets stuck during the compilation phase or the execution phase?

Additionally, does the internal pause refer to a JVM pause? If it does, is the pause occurring in HiveServer2 or Hive Metastore? In this scenario, a heap dump would provide better clarity on the context.

avatar
Rising Star

@uinn Help us in letting know the heap size set for both Hive and Hive Metastore services.
Is the issue happens while executing few specific queries or continuously the pause (JVM pause) is happening?
Is it appears at HiveMetastore or at Hiveserver2 level?