How to optimize Hive Performance ?
There are several types of Query Optimization Techniques we can use in Hive in order to Optimize Hive Performance.
- Tez-Execution Engine in Hive – Tez is a new application framework built on Hadoop Yarn that can execute complex directed acyclic graphs of general data processing tasks.
- Usage of Suitable File Format in Hive.
- Hive Partitioning
- Bucketing in Hive
- Cost-Based Optimization in Hive (CBO)