HiveServer2 often has internal pauses

[#1]

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

[#2]

@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.

[#3]

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

[#4]

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

[#5]

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.

[#6]

@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?