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