Articles & News

10 June 2021

Hue 4.10 and its new SQL Editor component, REST API, small File Importer and Slack App are out!

Hi Data Explorers, The Hue Team is glad to thanks all the contributors and release Hue 4.10!  Here is a summary of the main improvements of 4.10 on top of the previous 4.9 release: SQL Editor Component & API Now build your own SQL Editor in three HTML line by leveraging the SQL Scratchpad component. The first version of the public REST API for executing queries was also published.…

2 minutes read - Version 4.10 / Release

29 May 2021

Build your own SQL Editor (BYOE) in 5 minutes via Sql Scratchpad component and public REST API.

Leveraging the new Hue’s SQL Scratchpad Web Component and REST API into your own project. The Hue SQL Editor project has been evolving for more than 10 years and allows you to query any Database or Data Warehouse. Segmenting the overall project into fully decoupled components is one reason it could rapidly evolve and still be alive after so long. The already popular SQL Parser component is now joined by the SQL Scratchpad component.…

3 minutes read - Version 4.10 / Development / Query

26 May 2021

Improved Hue Importer -- Select a file, choose a dialect, create a table

If you’ve ever struggled with configuring Hue to allow your users to create new SQL tables from CSV files on their own in the public Cloud, you’ll be happy to learn that this is now much easier. If you're a pro Hue user, then you might be familiar with the Hue Importer. It lets you create tables from a file. Until now, the file had to be available on HDFS or cloud object storage, such as S3 or ABFS.…

2 minutes read - Version 4.10 / Development / Query

18 May 2021

Installing Hue Slack App in 3 Simple Steps!

Ever wondered about having a SQL Assistant which can help you to collaborate better with other SQL users in your team? That too in Slack itself!? This Slack Integration for Hue can fit those shoes for assisting you with your SQL queries in your Slack channels. Easy to use and now even easy to install for Slack workspace admins in just 3 simple steps! Kudos to Slack for recently rolling out its App Manifest beta feature for Slack Apps!…

2 minutes read - Version 4.10

23 April 2021

Provide your users proper S3 file access without giving them any credential keys

Using AWS S3 Signed URLs to list buckets, keys and manage files. SQL querying opens up your data and helps users take decisions backed by hard facts. However, what if the data they need is not present already in the Data Warehouse? In order to provide a more self service experience, they could bring their own data to query or join, then export and share the query results files etc.…

4 minutes read - Version 4.10 / Development

19 April 2021

Distribute your container App as a Package

Create and publish a Helm chart of your Kubernetes application. Helm is a package manager for Kubernetes and makes it simple to publish your app so that people can install it in three lines. For example with the Hue SQL Editor: helm repo add gethue helm repo update helm install hue gethue/hue 3-step process of packaging In the Helm world, chart is synonym of the traditional packages or modules of the Python or JavaScript world.…

2 minutes read - Version 4.10 / Development

09 April 2021

Collaborate on your SQL queries and results directly within Slack!

Introducing the Slack integration for Hue SQL Editor The Hue project which is celebrating its 11th anniversary this year is based on these three principles: Query. Explore. Share. The ‘Share’ principle got its last improvement with the introduction of Public Links and Gist Sharing for better collaboration. Following that path, it is time for the next improvement ;) What could be better than improving the collaboration by using one of the best communication platforms present - Slack!…

3 minutes read - Version 4.10

05 April 2021

Interactively Querying HBase via SQL - Tech Talk

Grow your user base able to leverage data stored in HBase via SQL queries with Apache Phoenix and the Hue Web SQL Editor. April 1st 2021 (not a joke ;) we did a tech talk (nicely organized by the Apache Phoenix project) on the underlying technology enabling SQL queries on Apache HBase tables. See the slides: Executing Phoenix queries in Hue SQL Editor For people not familiar with HBase, imagine a giant big table specialized in storing and updating in real time any type of records.…

2 minutes read - Version 4.10 / Phoenix

09 March 2021

Process & Learnings when upgrading the Webserver Stack - Django Upgrade (1.11 to 3.1)

The Hue project was started around 10 years back. In the meantime some of our technologies were getting old or deprecated, hence we need to upgrade them for the bright future of HUE. So In this, the Django upgrade was one of the most important ones. We were using Django 1.11 before this upgrade, for which extended support was ended in April 2020. Goal Hue running with Django 3.1 (latest) while still being able to compile/run with 1.…

4 minutes read - Version 4.10 / Development

06 March 2021

Performing Web/API Service upgrades without Downtime

By leveraging Kubernetes rollouts. This is a series of post describing how the Hue Query Service is being built. Automation well done frees-up from repetitive manual tasks while also documenting the process: team members get more productive at working at adding value instead and keep the momentum. Now, how to update automatically the refresh of the project websites without any downtime and manual steps. as well as (and not to forget jp.…

3 minutes read - Version 4.10 / Development

More recent stories

03 May 2023
Discover the power of Apache Ozone using the Hue File Browser
Read More
23 January 2023
Hue 4.11 and its new dialects and features are out!
Read More