Apache Hive Performance Tuning
Query results cache
Best practices for performance tuning
ORC file format
Advanced ORC properties
Performance improvement using partitions
Hive low-latency analytical processing
Bucketed tables in Hive