Support Questions

Find answers, ask questions, and share your expertise

Hive - Tool or Way to view history of hive queries and its execution timings

avatar
Contributor

Hi Friends,

We are facing a problem in monitoring the Hive queries execution. Basically, we need to have a tool or method to check the list of hive queries we're executing and performance of each query which ran in past. Cluster Admin is having tools to monitor the currently running queries only. Do you happen to know what tools can help here?

4 REPLIES 4

avatar
Expert Contributor

Hi, you take a look at the Tez view in ambari and also smartsense activity analysis - https://docs.hortonworks.com/HDPDocuments/SS1/SmartSense-1.4.0/bk_installation/content/activity_anal...

avatar
Contributor

thank you @Dennis Connolly. I'll check

avatar
Rising Star

Here is another link that might help: Using Tez View. This link goes to the the documentation about Tez View, a graphical UI in Ambari that can help you debug and optimize Hive queries that are run on a Tez framework.

avatar
Contributor

thank you @Frank Welsch. I'll check