question HiveServer2 often has internal pauses in Support Questions

HiveServer2 often has internal pauses

uinn — Mon, 01 Jul 2024 08:48:00 GMT

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

Re: HiveServer2 often has internal pauses

DianaTorres — Mon, 01 Jul 2024 17:22:05 GMT

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

Re: HiveServer2 often has internal pauses

uinn — Tue, 02 Jul 2024 05:15:39 GMT

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

Re: HiveServer2 often has internal pauses

DianaTorres — Mon, 08 Jul 2024 17:16:51 GMT

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

Re: HiveServer2 often has internal pauses

ggangadharan — Tue, 09 Jul 2024 07:52:34 GMT

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.

Re: HiveServer2 often has internal pauses

Mounika_Reddy — Tue, 09 Jul 2024 10:18:54 GMT

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