Apache Hive Performance Tuning
Low-latency analytical processing
Query results cache
Configuring the query results cache
Best practices for performance tuning
Maximizing storage resources using ORC
Advanced ORC properties
Improving performance using partitions
Handling bucketed tables