is there any way to find our number of hive queries ran in one day ?

SK1 — Thu, 16 Aug 2018 14:21:47 GMT

Hello ,

Actually I am looking for this because if we can find out similar queries then we can enable LLAP for them to get fast performance ? is it good idea or any other way to we can get better performance ?

Re: is there any way to find our number of hive queries ran in one day ?

JonathanSneep — Thu, 16 Aug 2018 15:02:23 GMT

I think SmartSense Activity Analyzer would be helpful to you. Have a look through this; https://docs.hortonworks.com/HDPDocuments/SS1/SmartSense-1.4.5/bk_installation/content/activity_analysis.html

You could also see reports of the following;

• Top N Longest Running Jobs
• Top N Resource Intensive Jobs
• Top N Resource Wasting Jobs
• Job Distribution By Type
• Top N Data IO Users
• CPU Usage By Queue
• Job Submission Trend By Day.Hour

https://docs.hortonworks.com/HDPDocuments/SS1/SmartSense-1.4.5/bk_user-guide/content/mr_notebook.html
You can also look at TEZ view in ambari, to analyze the hive queries;

https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.2.2/bk_ambari-views/content/analyze_details_hive_queries.html

question Re: is there any way to find our number of hive queries ran in one day ? in Archives of Support Questions (Read Only)

is there any way to find our number of hive queries ran in one day ?

Re: is there any way to find our number of hive queries ran in one day ?