Easier administration of Hue with the new Threads and Metrics pages

Easier administration of Hue with the new Threads and Metrics pages

If you are an Administrator this post is for you! (in the contrary, the SQL Editor would be a great starting point).

In our last post we talked about how to optimally configure Hue with the Analytic Database engines Impala and Hive. This post describes how troubleshooting is getting easier for administrators, with the new Threads and Metrics pages. Those are in the Administration section, which can be accessed from the user menu:

The Administration page link when logged-in as an admin

 

Threads

Threads page can be very helpful in debugging purposes. It includes a daemonic thread and the thread objects serving concurrent requests. The host name, thread name identifier and current stack frame of each are displayed. Those are useful when Hue “hangs”, sometimes in case of a request too CPU intensive.

 

There is also a REST API to get the dump of Threads using ‘desktop/debug/threads’

 

Metrics

Hue uses the PyFormance Python library to collect the metrics. These metrics are represented as gauge, counters, meter, rate of events over time, histogram, statistical distribution of values. A REST API endpoint ‘/desktop/metrics/’ to get all the metrics dump as json is also exposed.

The below metrics of most concern to us are displayed on the page

  • requests.active
  • requests.exceptions
  • requests.response-time
  • threads.daemon
  • threads.total
  • users
  • users.active

One of the most useful ones are the percentiles of response time of requests and the count of active users.

Admins can either filter a particular property in all the metrics:

Or select a particular metric for all properties:

 

2 Comments

  1. Justin Miller 3 months ago

    This is great!! As a Hue admin and Cloudera customer I thank you! Can’t wait to see this reach my prod installs 🙂

  2. Ramesh 2 months ago

    Getting error message when query is executed and results are not getting displayed even if query got completed

    “The query is hanging and taking longer than expected”

Leave a reply

Your email address will not be published. Required fields are marked *

*