26 June 2024

Integrating Trino Editor in Hue: Supporting Data Mesh and SQL Federation

Hello Everyone! Hue Editor, the open-source SQL Assistant for querying databases and data warehouses, is now extending its support to Trino. This integration marks a significant step in enhancing data mesh and SQL federation capabilities. What is Trino? Trino is a powerful tool for querying massive datasets, particularly useful for those dealing with terabytes or petabytes of data. Unlike traditional tools that rely on MapReduce jobs, Trino efficiently handles distributed queries across various data sources, including Hadoop's HDFS, relational databases, and NoSQL systems like Cassandra.…

2 minutes read - Version 5.0 / Trino

03 May 2023

Discover the power of Apache Ozone using the Hue File Browser

Greetings, Ozone users! Hue officially supports browsing Apache Ozone using the Hue File Browser. Hue can be set-up to seamlessly read and write to a configured Apache Ozone filesystem service, and users can directly query from and save data in it. Exploring the Ozone filesystem using Hue Apache Ozone is a highly scalable, distributed storage solution for analytics, big data, and cloud native applications. It is an efficient object store and optimized for filesystem operations.…

2 minutes read - Version 5.0 / Browsing

02 March 2023

Hue community 2023

Hello everyone! Last year was a bit slow for the open-source community around Hue, but we plan to change that in 2023. There will be more frequent releases, an improved issue-handling process, and a larger initiative to engage more people outside Cloudera. We want the Hue community to be vibrant, active, and inclusive. We will try to lower the threshold for those who wish to engage by simplifying, encouraging, and rewarding contributions in all forms.…

2 minutes read - community / development

23 January 2023

Hue 4.11 and its new dialects and features are out!

Hi Data Explorers, The Hue team is glad to release Hue 4.11. Thanks to all the contributors!  Note: Hue 4.11 is the last release to support Python 2.7. New releases will be based on Python 3.8 and higher. Here's a summary of what's new in Hue 4.11: Ability to import and query Iceberg tables from Hue Apache Iceberg is a high-performance table format and extends multifunction analytics to a petabyte scale for multi-cloud and hybrid use cases.…

3 minutes read - Version 4.11 / Release

11 October 2022

Creating Iceberg tables in Hue

Overview of Iceberg Apache Iceberg is a high-performance format for huge analytic tables. Iceberg brings the reliability and simplicity of SQL tables to big data, while making it possible for engines like Spark, Trino, Flink, Presto, Hive and Impala to safely work with the same tables, at the same time. Hue supports various dialects such as Hive, Impala, SparkSQL, Phoenix, and so on. In the past year, Hue importer has been upgraded with new features and improvements.…

1 minute read - Version 4.11 / Query

01 February 2022

HPL/SQL Support

HPL/SQL is an Apache open source procedural extension for SQL for Hive users. It has its own grammar. It is included with Apache Hive from version 2.0. HPL/SQL is a hybrid and heterogeneous language that understands syntaxes and semantics of almost any existing procedural SQL dialect, and you can use it with any database. For example, you can run existing Oracle PL/SQL code on Apache Hive and Microsoft SQL Server, or Transact-SQL code on Oracle, Cloudera Impala, or Amazon Redshift.…

2 minutes read - Version 4.11 / Development / Query

15 November 2021

Create SQL tables from excel files

If you are a Hue user then you might be familiar with the Hue Importer. It lets you create tables from a CSV file. Now you can also create SQL tables by importing Excel files into Hue. We have 2 options for file import Direct Importer Note: Supports (.xlsx) excel file type only. Remote Importer Note: Python2 based Hue does not support remote excel file importer. You can try this feature in the latest Hue version or at demo.…

1 minute read - Version 4.11 / Development / Query

21 September 2021

Access your data in ABFS without any credential keys!

Using Shared Access Signatures (SAS) to manage files and its operations Previously, we talked about providing S3 data access without giving out actual credentials via S3 signed URLs. This time, this feature is coming for another major cloud provider in the market, Microsoft Azure! This main use case remains the same which is to keep things simple for the end users and walk one more step on the path towards unlocking true self-service querying.…

3 minutes read - Version 4.11 / Development / Browsing

14 September 2021

SSO for REST APIs with your custom JWT authentication

Leveraging Hue as an API Service The Hue SQL Editor allows you to query any Database or Data Warehouse. Initially Hue had private APIs which could be used by the Hue UI only (because they could've changed, auth cookie based, lot of historical parameters etc). For example, if anyone had set up their own Hue instance, then it was very difficult for any other external services to use the APIs which Hue provides.…

3 minutes read - Version 4.11 / Development

17 August 2021

Create Phoenix tables in Just 2 steps

Hue started supporting Phoenix dialect in Hue in August 2019, in the meantime, if you’ve ever struggled with creating Phoenix tables from CSV files, you’ll be happy to learn that this is now much easier. Now, you can create a Phoenix table in just 2 steps. Choose a file Load the data and choose a primary key You can try this feature in the latest Hue version or at demo.…

1 minute read - Version 4.11 / Query