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 get most frequent running hiev queries ?

Is there any way to get most frequent running hiev queries ?

Guru

Team,

Is there a way to get a list of most frequently executed queries from the digital guys? Top 5 should be fine.

2 REPLIES 2
Highlighted

Re: Is there any way to get most frequent running hiev queries ?

Super Guru

@Saurabh

If you install Smartsense, following information is provided under MapReduce and Tez dashboard (there is a similar YARN dashboard which you might find helpful). Job Submission Trend by Day.Hour is the closest to what you are looking for.

  • 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.3.0/bk_user-guide/content/mr_notebook.htm...
  • i would highly recommend to check this blog.
  • http://hortonworks.com/blog/whats-new-smartsense-1-3/
  • Highlighted

    Re: Is there any way to get most frequent running hiev queries ?

    Guru

    @mqureshi: Yes you are right I am looking something like this. But I do not see Top N hive queries dashboard in smartsense, so do you know wether we can add such dashboard or not? or it is already avialble in smartsense.

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