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.

Hue Queries for Operationall Metrics

Hue Queries for Operationall Metrics

New Contributor

Hi

 

Can anyone say, how to get the answers for the below queries on HUE

 

1. Total # of Hue Users
2. Total # of Queries
3. Total # of Unique ODBC users
4. Total # of Hue/ODBC Users this week/month
5. Total # of queries (this week/month) listed by user
and access type
6. Total # of Hadoop Jobs per query listed by user
(this could be a metric of query complexity)
7. Hadoop metrics: # of Jobs, # of tasks per job

Some metric on the # of recent queries.
=======================================
1. Query length
2. Avg. length of query
3. Avg. length of query listed by user and access type

4. Top TEN longest queries
5. Top TEN users (by logins and duration if possible)
6. Top Active times during Month (what days/hours were most active)

 

Thanks

1 REPLY 1

Re: Hue Queries for Operationall Metrics

You should checkout the Hue database:
http://gethue.com/how-to-manage-the-hue-database-with-the-shell/

Then the Hadoop logs or Cloudera Manager for the missing pieces!

Romain