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:
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.
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.
Use Query Spotlight to:
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.
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.