Articles & News
Category:

19 August 2020

Quickstart Hue in Docker and query any of your Database

Query any Data Warehouse in minutes! In this tutorial we configure Hue to use an existing MySQL database and point to an Apache Hive data warehouse that we want to query. Note If you are looking another warehouse than Hive, check out all the other connectors. There are two important concepts: Persistence: Hue needs an existing database with transactions like MySQL to support concurrent requests and also not lose the registered users, saved queries, sharing permissions… when the server gets stopped.…

3 minutes read - Administration / Version 4.8

15 August 2020

Automatically checking the Python style and title format of Git commits

Hi Query Engineers, The investment in Continuous Integration (CI) and automation continues in order to help scale the resource and quality of the Hue project. This past year saw a lot of improvements with: An integrated commit flow automatically run by Circle CI gethue.com and demo.gethue.com websites link checking JavaScript styling and artifacts licensing check Here is the latest about how to automatically check that the coding convention of the Python API is followed by everybody as well as the format of the git commit titles.…

4 minutes read - Administration / Version 4.8

23 June 2020

Monitoring Hue activity with Grafana Dashboards

Besides Hue Active Users Metric Improvements, we’ve also added a new Prometheus metrics number of queries, which shows how many queries were executed in the last ten minutes. Now both of them are available in Hue’s Grafana dashboard. Let’s go to the Grafana dashboard list, you will find Hue’s Home dashboard in the Hue folder. After opening the Home dashboard, you will see four panels which list CPU, memory, active users, and number of queries.…

1 minute read - Administration / Version 4.8

22 June 2020

Automated checks for JavaScript modules compatible licenses and non absolute paths with Continuous Integration

Hi Interface Builders, The investment in Continuous Integration (CI) and automation continues in order to help scale the resource and quality of the Hue project. This past year saw a lot of improvements with an integrated commit flow and adding series of link checking automatically run by Circle CI. Here is the latest about how to automatically check that JavaScript artifacts have the correct licensing and do not contain absolute paths.…

2 minutes read - Administration / Version 4.8

19 May 2020

How to grant Ranger permissions for a new user on a Secure Cluster

Hello, Hue administrators, The Apache Ranger™is a framework to enable, monitor and manage comprehensive data security across the Hadoop platform. Hue integrates with Ranger since Hue4.6, on any secure cluster with Ranger installed, the user has to have proper permissions to operate on the data to avoid following permission warning. Here let's show the detailed steps to grant permission for any new user through CM UI. Steps On any CM managed cluster, you can navigate to Ranger service, note down the ‘Ranger Usersync’ host on “Instances” tab, then open ‘Ranger Admin Web UI’ open a terminal and ssh to your ranger usersync host which you noted down at Step 1;…

2 minutes read - Administration / Version 4.8

05 May 2020

How to Configure Hue to authenticate with Apache Knox SSO on a Secure Cluster

Hello, Hue administrators, The Apache Knox™ Gateway is an Application Gateway for interacting with the REST APIs and UIs of Apache Hadoop deployments. Hue supports KnoxSpnegoDjango since Hue4.6, we can turn on Hue’s KnoxSpnegoDjango auth by updating Hue configurations through CM UI or hue.ini. On any cluster with Knox service installed, update hue.ini as following and restart Hue: [desktop] [[auth]] backend=desktop.auth.backend.KnoxSpnegoDjangoBackend [[knox]] knox_principal=knox knox_proxyhosts=weixia-1.domain.site,weixia-2.domain.site Or on any CM managed cluster, Hue can be configured with KnoxSpnegoDjango backend through CM UI: Fill knox_proxyhosts field with accurate knox proxy hostname, you can get the hosts by navigating to Clusters->KNOX, and click on ‘Instances’ tab: For Knox HA cluster, you can fill in all the hosts by clicking on “+” icon: Click ‘Save Changes’, you will see a warning about role missing kerberos keytab.…

2 minutes read - Administration / Version 4.8

07 April 2020

Admin improvements coming in 4.7!

Hi SQL crunchers, The upcoming 4.7 release brings a series of improvements to make the life of the admin better. Here is a selection: All the server properties are listed on the admin page as well as the location of the config page. This is a lot of parameters and sections! Now those can be spot light search via a filter. The delete flow of a user now disables instead of deleting (to avoid losing the saved documents and queries).…

1 minute read - Version 4.7 / Administration

01 April 2020

Hue Active Users Metric Improvements

To understand the performance of Hue, we want to know how many active users in Hue–and more specifically–how many on each host. An active user is who sends requests from his/her browser to the Hue server in the last one hour. Recently, Hue got some improvements for providing and displaying better metrics. On premise, Hue is using PyFormance implements /desktop/metrics endpoint. Cloudera Manager collects data via the endpoint and displays the metric “Active Users” in the Charts Library, but all hosts show the same number of active users.…

2 minutes read - Administration / Version 4.7

01 April 2020

Set Up Prometheus Server without Kubernetes

To taste Hue prometheus metrics, you may set up a Prometheus server to scrape the metrics endpoint /metrics on a Hue server (which may not need to run in docker or Kubernetes). Here is the set up example on Ubuntu 16.4. Prerequisites: a Hue server running at localhost:8000. Create a service user $ sudo useradd --no-create-home --shell /bin/false prometheus `` Create a directory in /etc for Prometheus’ configuration files and a directory in /var/lib for its data…

2 minutes read - Administration / Version 4.7

11 March 2020

Automatically checking documentation and website dead links with Continuous Integration

Hi Data Crunchers, Continuous integration and automation are investment that enable a major scaling in the resource and quality of software projects. This past year saw a lot of improvements with an integrated commit flow and adding series of checks like linting of JavaScript, also running Python 3 tests automatically… This also create a virtuous circle that encourages developers to add more tests on their own (e.g. +200 since the beginning of this year), as all the plumbing is already done for them.…

1 minute read - Administration / Version 4.7

More recent stories

23 September 2020
Hue 4.8 and its improvements are out!
Read More
15 September 2020
SQL Querying Improvements: Phoenix, Flink, SparkSql, ERD Table...
Read More
14 September 2020
REST API for sending SQL queries and Browsing files
Read More