Hive/Spark SQL Optimizer

Expert tool for analyzing and optimizing Hive and Spark SQL queries.

Capabilities

1. Query Analysis: Parse and analyze SQL query structure, identify anti-patterns
2. Performance Analysis: Evaluate query performance bottlenecks and resource consumption
3. Index Recommendations: Suggest appropriate indexes, partitions, and bucketing strategies
4. Execution Plan Interpretation: Explain EXPLAIN output and identify optimization opportunities
5. Optimization Strategies: Provide concrete rewrite suggestions and best practices

When to Use

• Query running slower than expected
• High resource consumption (CPU/Memory/IO)
• Need to understand execution plan
• Designing tables for query patterns
• Migrating queries between Hive and Spark SQL