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