Cloudera Documentation
How ToPDF version

Query and job resource optimization using resource efficiency analysis

You can evaluate the efficiency of individual jobs or queries based on the insights related to the resources requested versus the actual consumption. Queries or jobs with excess resource allocation waste cluster resources that can be better utilized for other tasks. Therefore, it is important to identify and analyze these inefficient jobs or queries.

The Cloudera Observability Resource efficiency analysis helps you understand how efficiently the allocated resources are used.
  • Capability: Requires the Cloudera Observability Premium on cloud license tier. To learn more about the Cloudera Observability Premium on cloud license tier and to request a demo, see the Cloudera Observability product website.
  • Environments: Available for Cloudera Base on premises and Cloudera Data Hub environments.
  • Engines: Available for Hive and Spark engines.
The Cloudera Observability Query Cost or Job Cost analysis shows a breakdown of the query or job to help you understand the costs better.
  • Capability: Requires the Cloudera Observability Premium on cloud license tier.
  • Environments: Available for Cloudera Base on premises, Cloudera Data Hub, and Cloudera Data Warehouse environments.
  • Engines: Available for Hive, Impala, and Spark engines.

  • Identifies inefficiencies: Highlight jobs or queries that over-allocate resources such as CPU and memory.
  • Optimizes resource allocation: Ensure resources are allocated more efficiently, reducing waste and improving overall system performance.
  • Cost analysis: Provides insights into costs associated with different resources used by the query.

We want your opinion

How can we improve this page?

What kind of feedback do you have?