Created 07-01-2024 01:48 AM
Hi
For example, the hive component of cluster CDH often has internal pause. How to tune it?
CDH version : CDH 6.3.2
Created 07-01-2024 10:22 AM
@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,Created 07-01-2024 10:15 PM
Thank you, but my problem hasn't been solved yet
Created 07-08-2024 10:16 AM
Created 07-09-2024 12:52 AM
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.
Created 07-09-2024 03:18 AM
@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?