Chapter 3. Hive High Performance Best Practices
The following sections in this chapter describe best practices for increasing Hive performance:
Apache Hive Performance Tuning
Also available as:
- 1. Hive Architectural Overview
- 2. Interactive SQL Query with Apache Hive LLAP (Technical Preview)
- 3. Hive High Performance Best Practices
- Use the Tez Query Execution Engine
- Debug Hive Queries with Tez View in Ambari
- Use the ORC File Format
- Use Column Statistics and the Cost-Based Optimizer (CBO)
- Design Data Storage Smartly
- Better Workload Management by Using Queues
- Hive Setup for Using Multiple Queues
- Guidelines for Interactive Queues
- Guidelines for a Mix of Batch and Interactive Queues
- Create and Configure YARN Capacity Scheduler Queues
- Refreshing YARN Queues with Changed Settings
- Setting Up Interactive Queues for HDP 2.2
- Hive, Tez, and YARN Settings in Ambari 2.1 and HDP 2.3
- Setting Up Queues for Mixed Interactive and Batch Workloads
- 4. Configuring Memory Usage
- 5. Query Optimization