Support Questions

Find answers, ask questions, and share your expertise

Hive set parameters and impact - understanding

Explorer

All,

I want to learn how to use various settings ( set hive.tez... etc ) in hive for tuning and whats meaning of each and impacts of each ... where can i study each of them and see the effect of each setting during execution.

Also is there extensive list of each of them ?

We been strugling big time for identifying right settings to use, and simulate exact issues in lower environment like prod ?

Thanks

Freakabhi

1 REPLY 1

Super Mentor
@Abhijeet Rajput

The following articles and docs might give you a base for starting the Hive Tuning and will get some idea on using various tuning parameters

Optimizing Hive queries: https://community.hortonworks.com/articles/68631/optimizing-hive-queries-for-orc-formatted-tables.ht...

5 Ways to Make Your Hive Queries Run Faster: https://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/

Optimizing an Apache Hive Data Warehouse (Tez / LLAP engines): https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_hive-performance-tuning/content/ch_hive-...

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.