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
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:
