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
Apache Tez and Hive LLAP
Bucketed tables in Hive