How to optimize Hive Performance?

This topic has 1 reply, 1 voice, and was last updated 5 years, 7 months ago by DataFlair Team.

Viewing 1 reply thread

Author

Posts
- September 20, 2018 at 12:09 pm #4756
  
  DataFlair Team
  Spectator
  
  How will you optimize Hive Performance?
- September 20, 2018 at 12:10 pm #4758
  
  DataFlair Team
  Spectator
  
  Basically, Hive is a query language which is similar to SQL built on Hadoop ecosystem, which runs queries on petabytes of data. Though we need to improve its performance, for that there are several Hive optimization techniques which we can implement when we run our hive queries.
  
  So, for Hive Performance Tuning, here are some Hive optimization techniques available:
  
  a. Tez-Execution Engine in Hive
  b. Usage of Suitable File Format in Hive
  c. Hive Partitioning
  d. Bucketing in Hive
  e. Vectorization In Hive
  f. Cost-Based Optimization in Hive (CBO)
  g. Hive Indexing
  
  well, to learn all these optimization techniques in detail, follow the link: 7 Best Hive Optimization Techniques – Hive Performance
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.