Articles & News

05 December 2019

Hue 4.6 and its improvements are out!

Hi Data Explorers,   The Hue Team is glad to thanks all the contributors and release Hue 4.6!   The focus of this release was to keep building on top of 4.5 and modularize the tech stack, improve SQL integrations and prepare major upcoming features of Hue 5. In particular now: Python 3 support can be tested There is a new version of gethue.com and the content of docs.…

3 minutes read - Version 4.6 / Release

13 November 2019

Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types

Hi SQL crunchers, The Datawarehouse ecosystem with Apache Hive and Apache Impala is getting more complete with the introduction of transactions. In practice, this means your tables can now support Primary Keys, INSERTs, DELETEs and UPDATEs as well as Partition Keys. Here is a tutorial demoing how Hue’s SQL Editor helps you quickly visualize and use these instructions via its assists and autocomplete components. Primary Keys Primary Keys shows up like Partition Keys with the lock icon:…

3 minutes read - Version 4.6 / Querying

31 October 2019

Missing some color? How to improve or add your own SQL syntax Highlighter

Hue’s Editor SQL functionalities makes it much more easier to query your databases and datawarehouses. It was previously described about how to improve or create your own SQL autocompleter so that the Querying Experience gets even more effective. This post is about going one step further and improving the SQL syntax highlighting. New keywords might not be properly colored highlighted in the editor. This is especially true when adding a new language.…

2 minutes read - Editor / Notebook / Hue 4.6

24 October 2019

How to create a HBase table on Kerberized Hadoop clusters

Hi SQL Data Explorers, If you are using HBase with Hue on CDH6.1.x or later, you may find Hue’s check configuration fails for HBase with following error: Failed to authenticate to HBase Thrift Server, check authentication configurations. With change from HBase(HBASE-19852), we have to configure HBase properly through Cloudera Manager with following steps to enable Hue-Hbase communication. Step 1 Navigate to CM->Clusters->HBASE-1->Configurations, search for “thrift” and verify the “Enable HBase Thrift Http Server” and “Enable HBase Thrift Proxy Users” are checked, and “Enable HBase Thrift Server Compact Protocol” and “Enable HBase Thrift Server Framed Transport” are unchecked.…

2 minutes read - HBase / Hue 4.3 / Hue 4.4 / Hue 4.5

17 October 2019

Easily checking for deadlinks on docs.gethue.com

docs.gethue.com 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

10 October 2019

Integration with Microsoft Azure Data Lake Store Gen2

Hue continues its progress to make the Cloud platforms easier to use. We’re happy to preset compatibility with Microsoft Azure Data Lake Store Gen2 (ADLS Gen2). Hue 4.6 release brings the ability to read and write from a configured ADLS Gen2. Almost like ADLS, users can save data to ADLS Gen2 without copying or moving to HDFS. The difference between ADLS Gen1 and Gen2 is that ADLS Gen2 does not rely on the HDFS driver.…

3 minutes read - Browsing / 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

12 August 2019

Hue 4.5 and its improvements are out!

Hi SQL Data Explorers,   The Hue Team is glad to thanks all the contributors and release Hue 4.5! The focus of this release was to modularize the tech stack, improve SQL integrations and prepare major upcoming features. This release comes with 660 commits and 150+ bug fixes! For all the changes, check out the release notes. They are several ways to give it a spin! Tarball or source From Docker Hub…

1 minute read - Querying / Version 4.5 / Release

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