Articles & News
Category:

15 September 2020

SQL Querying Improvements: Phoenix, Flink, SparkSql, ERD Table...

Hi Data Crunchers, Are you looking at executing your SQL queries more easily? Here is a series of various querying improvements coming in the next release of Hue! New Databases Hue is getting a more polished experience with Apache Phoenix, Apacke Flink SQL and Apache Spark SQL (via Apache Livy). Apache Phoenix Apache Phoenix makes it easy to query the Apache HBase database via SQL. Now the integration is fully working out of the box and several corner cases (e.…

4 minutes read - Version 4.8 / Querying

06 May 2020

SQL Editor for Apache Flink SQL

Flink SQL Editor This is the very first version of the SQL Editor for Flink. The goal is to demo how to execute Flink SQL queries. We use the new Flink SQL gateway project and point to a Flink cluster with live data in a docker container. Hue is used as the SQL Editor for querying Flink tables. Feel free to read more about Flink SQL and continuous queries. Setup Any Flink 1.…

4 minutes read - Querying / Version 4.8

30 April 2020

SQL Editor for Apache Impala

Impala SQL Apache Impala is a fast SQL engine for your data warehouse. Want to give it a quick try in 3 minutes? Here is how! Starting Impala First make sure your have docker installed in your system. Then, based on the great tutorial of Apache Kudu (which we will cover next, but in the meantime the Kudu Quickstart is worth a look), just execute: docker run -d --name kudu-impala -p 21000:21000 -p 21050:21050 -p 25000:25000 -p 25010:25010 -p 25020:25020 --memory=4096m apache/kudu:impala-latest impala Afterwards, docker ps should show:…

2 minutes read - Querying / Version 4.8

27 April 2020

SQL Editor for Apache Spark SQL with Livy

Spark SQL Spark SQL is convenient for embedding clean data querying logic within your Spark apps. Hue brings an Editor so that it is easier to develop your SQL snippets. As detailed in the documentation, Spark SQL comes with different connectors. Here we will just show with Livy. Apache Livy provides a bridge to a running Spark interpreter so that SQL, pyspark and scala snippets can be executed interactively. In the hue.…

1 minute read - Querying / Version 4.8

04 March 2020

A better collaborative Data Warehouse Experience with SQL query sharing via links or gists

Hi Data Crunchers, For the past 10 years, Hue's SQL Editor has been targeting the SQL Data Warehouse Experience. It recently got better support for typing SQL queries by showing column keys. The latest improvement is about better collaboration. Via the document sharing capabilities and query parameterization, Hue allows teams to build their own query bank of knowledge. To complement this, something quicker and easier is now also available: Public link & Gist sharing.…

2 minutes read - Version 4.7 / Querying

27 February 2020

Re-using the JavaScript SQL Parser

SQL autocompletion The parser is running on the client side and comes with just a few megabytes of JavaScript that are then cached by the browser. This provides a very reactive & rich experience to the end users and allows to import it as a module dependency. While the dynamic content like the list of tables, columns.. is obviously fetched via remote endpoints, all the SQL knowledge of the statements is available.…

3 minutes read - Version 4.7 / Querying / Development

10 February 2020

The Hue SQL Query Experience for your Data Warehouse

Hue has just blown its 10th candle! In this follow-up #2 of the series, let's describe what a SQL Cloud Editor is. The top two capabilities of a SQL Cloud Editor are: Data Querying Experience: offer a SQL querying assistant that helps users self service their own query need while educating them on the data and syntax know-how. Cloud Native: scale by providing as much as “no-ops” as possible by automating the operation of the service.…

12 minutes read - Version 4.7 / Querying

28 January 2020

10 years of Data Querying Experience Evolution with Hue

Hue has just blown its 10th candle. Hue was created when Apache Hadoop was still in its infancy before becoming mainstream (read more about the Hadoop story in Hadoop is Dead. Long live Hadoop). Hue originally was a part of Cloudera Manager, which was proprietary and focused more on the administrators but was then moved out to its own open source project in version 0.3. Hue then gradually evolved from being a desktop like application to a modern single page SQL Editor (and is at version 4.…

3 minutes read - Version 4.7 / Querying

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 / 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 - Querying / Version 4

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