Webinar: Proven Approaches to Hive Query Tuning

Webinar: Proven Approaches to Hive Query Tuning

photo content image 1 2

Visibility into Query Performance and Execution

Query Spotlight makes it easy for operators and developers to understand the detailed hive query performance characteristics of their query and workloads together with infrastructure-wide issues that impact these workloads. With this new functionality, query workloads can be tuned, debugged and optimized for better performance and reduced costs, both in the cloud and on-premises. Query Spotlight enables you to:

  • Understand and manage utilization and Impala query performance with a single dashboard that includes time-correlated query views, database and infrastructure metrics, query run summaries, tables accessed, and query plans mapped to execution stages.
  • Get a quick root cause analysis with detailed visibility into query workloads, including delayed and the most expensive queries, as well as wasted CPU and memory queries.
  • Monitor technologies and frameworks including your Apache Impala, Hive, IBM BigSQL, Redshift, and Snowflake query performance.
photo content image 9

Get Hive-Specific SQL Query Planning

Query Spotlight enables developers to see Hive-specific SQL query planning and execution information, rapidly ascertain query plan problems, analyze Hive query performance, identify bottlenecks that contribute to slow queries, and speed time to resolution. Operators can quickly narrow down problematic queries in a multi-user environment and use query performance insights to optimize cluster resources and improve productivity.

photo content image 8

Create and Receive Alerts on Query Health and Performance

In addition to visualizing detailed query information on resource utilization and database views, Query Spotlight enables you to create and receive alerts about queries, remediate issues, and optimize query performance.

Improve your Query Performance with Real Insight eBook.

Use Query Spotlight to:

  • Highlight hot partitions, outdated table statistics, and other system and storage issues.
  • Receive notifications about execution plan skew, poorly optimized queries, and historical runtime variance.
  • Use query data to alert and identify which applications will miss SLAs.


Query Spotlight Now Supports Apache Impala

Query Spotlight Now supports Apache Impala — one of the leading players in interactive SQL query engines.

Query Spotlight makes it easier for operators and developers to understand the detailed performance characteristics of their query workloads together with related infrastructure-wide issues. The product allows query workloads to be tuned, debugged and optimized for better performance and reduced costs in the cloud and on premises.

Query Spotlight for Impala displays detailed stats, query plan, breakup of the query duration by every step and also provides visibility into databases and tables. The recommendation engine includes system level recommendations as well as query level recommendations—joins included.

Benefits for Your Team

intro content icon 1

Operation Teams

  • Capture real-time metrics, including CPU usage, database access patterns, runtime, and query history to provide instant reference points and feedback for optimizing performance.
  • Optimize the monitoring and management of on-prem and cloud resources with detailed query cost information.
intro content icon 2

Application teams

  • Display lists of top queries: most rows read, most rows written, and most compute-intensive.
  • Summarize query runs, including the number of stages, mappers, and reducers.
intro content icon 3

Business Teams

  • Better understand analytics workloads.
  • Improve collaboration between developers and operators who can now share a unified and detailed runtime view of the query environment.
  • Leverage other Pepperdata analytics stack performance products to provide correlated application and infrastructure metrics.
Curve Pattern

Take a Free Thirty-Day Trial to See What Big Data Success Looks Like

Pepperdata products provide complete visibility and automation for your big data environment. Get the observability, automated tuning, recommendations, and alerting you need to efficiently and autonomously optimize big data environments at scale.