Articles & News

17 October 2019

Easily checking for deadlinks on are getting some refreshed content continuously. In addition, a series of links not working (returning a 404) have been fixed. Here is how it was done. First we used the muffet tool. muffet is a fast link checker crawler, very easy to use: sudo snap install muffet Then after booting the hugo documentation server, we point to its url. We also blacklist certain urls to avoid some noisy false positives:…

2 minutes read - Administration / Version 4.6

24 September 2019

Introducing Hue requests tracing with Opentracing and Jaeger in Kubernetes

Hue is getting easy to run with its Docker container and Kubernetes Helm package. Recent blog posts describes how to get access to logs and metrics. Even in a non distributed world it can get noisy to know how much time is being spent where in each user request. Consequently, in the context of a Data Analyst, knowing why a certain query is slow can become problematic. On top of that, adding multiple tenants and users, and more than 20 external APIs and the fog about fine grain performances appears and its becomes extremely manual and time consuming to troubleshoot.…

3 minutes read - Administration / Querying / Version 4.6

16 September 2019

Collecting Hue metrics with Prometheus in Kubernetes

Hue is getting easy to run with its Docker container and Kubernetes Helm package. Hue metrics are useful for checking the load (how many users), slowness (average or percentile times taken by requests)… Those have been available via the /metrics page, but here is how to collect and aggregate this information in Kubernetes. Prometheus is the metric collecting system heavily used in the Kubernetes world. Here we will leverage the Microk8s distribution that bundles it.…

2 minutes read - Administration / Version 4.6

11 September 2019

Collecting and querying Hue logs with Fluentd in Kubernetes

Hue is getting easy to run with its Docker container and Kubernetes Helm package. Then when the service is up, let’s see how we can retrieve and analyse the logs. Fluentd is a log management system that is heavily used in the Kubernetes world. Here we will leverage the Microk8s distribution that bundles it.   First we install the fluentd add-on: microk8s.enable fluentd And see that the Elastic Search, Fluentd and Kibana UI are running:…

2 minutes read - Administration / Version 4.6

26 July 2019

Hue in Kubernetes

Let’s see how to automate the deployment further and run this into a container orchestration like Kubernetes.   We previously documented the Hue Docker image that provides the latest Hue web server into a “box”. Hue ships with a Helm chart to make it really easy to get started. Helm is a package manager for Kubernetes. More advanced, directly use the yaml config files. In a Shell, after installing Helm, just execute these three instructions to boot a live Hue with its database:…

1 minute read - Administration / Version 4.5

24 July 2019

Quick Start a Hue development environment in 3 minutes with Docker

Looking at simplifying the usage of Databases and Datawarehouses or learning how to build Cloud webapps? Hue would be a great candidate for you! Typically the development is made natively but here is a new way to quickly get started with Docker:   git clone cd hue cp desktop/conf/pseudo-distributed.ini.tmpl desktop/conf/pseudo-distributed.ini Then edit the [[database]] section to specify a proper database, here MySql: host= # Not localhost if Docker engine=mysql user=hue password=hue name=huedb Then map the local Hue source code into the running container (so that local edits are seen in the running Hue): sudo docker run -it -v $PWD/apps:/usr/share/hue/apps -v $PWD/desktop:/usr/share/hue/desktop -v $PWD/desktop/conf/pseudo-distributed.…

1 minute read - Administration / Version 4.5

19 July 2019

BYOA – Build Your Own Autocompleter

Hue is a SQL Editor integrating with the most common data warehouses and databases. Getting specialized autocomplete for each language brings better code maintainability (force a decoupled design), speed (no need to load all the parsers for only one language) and obviously a nicer end user experience (Impala, Hive, PostgreSQL… always have slight different syntax). In Hue we use generated parsers to handle autocomplete and syntax checking in the editors.…

8 minutes read - Administration / Querying / Version 4.5

12 June 2019

Improving the developer productivity with some Continuous Integration

Tooling and automation has been simplified dramatically with technologies like Docker and the Cloud. On top of this, continuous integration companies like Circle CI and Travis CI have added one more layer of simplicity. Background Hue‘s scope has been pretty wide (ranging from SQL parsers to CSS to scheduling jobs or querying any type of databases…) and the increase of external contributions has made the previous Development process outdated. It was becoming frequent to brake the master branch with errors or not making easy for developer to contribute by asking to manual run the test suite.…

4 minutes read - Administration / Version 4.5

16 April 2019

2x Faster page load time with the new bundling of JavaScript files

Fast page loads are notorious for providing a much nicer user experience. Who likes to wait or have a slow display of the page? In the continuous offer to render Hue snappier and at the same time modernize and improve the developer experience, JavaScript files are now bundled together and are importer only when needed (under the cover this is done by leveraging This is a lot of requests not happening anymore when opening Hue the first time!…

1 minute read - Administration / Version 4.5

12 April 2019

Documentation revamp: making Hue easier to install, use and develop

Making Hue easier to install, use and develop with a modern documentation. While all the efforts on the improving the core SQL Experience are important, not communicating clearly about it is not very efficient. In consequence, the documentation website was rewritten and its content is now being continuously refreshed. Before Can be seen in older version: After Can be seen in latest:     Table of content It was unified in the left navigation, and we now see the four sections within the same page:…

2 minutes read - Administration / Version 4.4 / Version 4.5

More recent stories

05 December 2019
Hue 4.6 and its improvements are out!
Read More
13 November 2019
Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
Read More
31 October 2019
Missing some color? How to improve or add your own SQL syntax Highlighter
Read More