Monitoring your Hive service

Identify Hive service problems that may be affecting your Hive workloads, such as queries that are running slow or that are failing, with the Cloudera Observability Hive cluster service metrics.

Describes where to view the Cloudera Observability Hive cluster service metrics and how to build your own service chart from the Cloudera Manager service metrics and Chart Builder.
  1. Verify that you are logged in to the Cloudera Observability web UI.
    1. In a supported browser, log into the Cloudera Data Platform (CDP).
      The CDP Public Cloud web interface landing page opens.
    2. From the Your Enterprise Data Cloud landing page, select the Observability tile.
      The Cloudera Observability landing page opens.
  2. In the Clusters page, select the cluster required for analysis.
  3. From the time-range list in the Cluster Summary page, select a time period that meets your requirements.
  4. In the Cluster Summary page, locate the Hive query of interest by doing one of the following:
    • From the Usage Analysis chart, click Hive and then from the Slow Queries chart widget in the Hive summary page, click the query of interest.
    • From the Trend chart, select the Hive tab and then click its Total Queries value. From the Job column in the Hive/Queries page, locate and click the query of interest.
  5. From the Hive/Queries/ queryname page, select the Cluster tab.
    The Analysis page opens, which lists the Hive cluster health check metrics that are performed by Cloudera Observability at the end of a Hive job.
  6. Select, either the metric you require for analysis or a metric that displays a red or yellow icon adjacent to the metric, which represents the threshold warning or error state for at least one unhealthy role instance.
    The Analysis summary page opens, which describes the health check metric performed by Cloudera Observability on the Hive service, the severity conditions and thresholds, and the remediation actions you should consider to resolve a problem. It also contains:
    • The Analysis chart, which displays the severity condition of the operation during the job run and displays the state of each role instance 5 minutes before the start of the job and 5 minutes after the job has completed.
    • The Host Status section, which displays the full list of workload role instances and the hosts they are running on, their health check result, and the severity state icon.
  7. (Optional) To build your own chart from a Cloudera Manager health check service metric, click the Metrics option and do the following:
    1. From the Service Name list, select a service that you are running on your workloads cluster.
    2. From the Metric Name list, select the name of the Cloudera Manager health test metric.
    3. Click View.