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.

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

Solved Go to solution

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

Guru

Hello ,

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

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

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

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

1 REPLY 1
Highlighted

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

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here