Articles & News
Category:

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

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

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

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

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

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

01 April 2019

Hive on Tez integrations improvements

We’ve made some improvements when using Apache TEZ as the query engine of the SQL Editor: When running a query, the job id will now show up in the query log. Pressing the id will show the job in the mini job browser. TEZ, does not update its progress in the log, but if you’ve opened the mini job browser, Hue will be able to update the job’s progress right in the editor.…

1 minute read - Querying / Version 4.4

28 March 2019

Hue 4.4 and its improvements are out!

Hi Big Data Explorers,   The Hue Team is glad to thanks all the contributors and release Hue 4.4!    The focus of this release was to improve the self service SQL troubleshooting and stability. This release comes with 450 commits and 80+ bug fixes! For all the changes, check out the release notes. Go grab the tarball or source, and give it a spin! And for a quick try, ’docker pull gethue/4.…

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