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

• • Vectorization In Hive

• Cost-Based Optimization in Hive (CBO)