I wanted to understand how to approach to the solution of hive query failures;
what tools are good or being used to analyze issues in hive queries or map/reduce level?
1. Vertex Issue / Out of Memory issue indicate the configurations are not tuned.
2. In HS2 logs, look for exceptions and the stack trace that follows to give you a better picture.
3. You can use Tez View to debug Hive Performance Issues: https://docs.hortonworks.com/HDPDocuments/Ambari-220.127.116.11/bk_ambari-views/content/ch_using_tez_view.h...
4. You can refer to following links to understand various config parameters and its values: