Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive set parameters and impact - understanding

Highlighted

Hive set parameters and impact - understanding

New Contributor

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

Re: Hive set parameters and impact - understanding

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-...