Apache Hive Performance Tuning
Query results cache
Managing high partition workloads
Best practices for performance tuning
ORC file format
Advanced ORC properties
Performance improvement using partitions
Bucketed tables in Hive