Articles & News

09 August 2019

Built-in Hive language reference in the SQL Editor

Similarly to the Apache Impala dialect, the Editor now provides a direct access to Hive documentation in the right panel. It is also still possible to right click on an instruction to get more details about it. We hope that it makes your SQL querying even more productive!   Any feedback or question? Feel free to comment here or on the Forum or @gethue and quick start SQL querying!…

1 minute read - Querying / Browsing / Version 4.5

07 August 2019

SQL querying Apache HBase with Apache Phoenix

Apache Phoenix is a great addon to extent SQL on top of Apache HBase, the non relational distributed data store. On top of the HBase Browser, now the Editor provides a more common syntax for querying the data. Note that being a key/value store, the SQL can have different idioms, and the Editor interface still requires some polishing to fully support all the SQL UX capabilities of Hue. In this first blog post about Phoenix, let’s follow Phoenix’s 15-minute tutorial then query the US_POPULATION table via the Editor:…

2 minutes read - Querying / Browsing / Version 4.5

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 https://github.com/cloudera/hue.git 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=127.0.0.1 # 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

20 June 2019

Realtime catalog search with Hue and Apache Atlas

With the latest Hue (future 4.5 release), we are glad to announce that Hue integrates with Apache Atlas as backend to enable SQL users for real time data catalog searching. Previously Hue’s catalog was powered by Cloudera Navigator only, but now the API is generic and could potentially support other Catalog services too. The nice end user experience for finding content to query can be transparently re-used. With this first integration, Hue lists properties of entities like classifications and provides real time search among thousands of possible tables or databases:…

2 minutes read - 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 https://webpack.js.org/). 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: http://cloudera.github.io/hue/docs-4.3.0/ After Can be seen in latest: http://cloudera.github.io/hue/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

10 April 2019

How to enable new user and create Hive tables on a Kerberized secure cluster with Apache Sentry

It can be tricky to grant a new user proper permissions on a secure cluster, let’s walk through the steps to enable any new user for table creation on a kerberized cluster. Depends on your cluster size, creating user and group on each node can be tedious. Here we use pssh (Parallel ssh) for this task. 1. Install the tool and prepare a file which contains all your hosts. For Mac user:…

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