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