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

13 August 2021

Object/File Storage public REST API

Leveraging more REST API into your own project: list, upload, download… data files. This post comes with a live tutorial of the file listing API. The Hue SQL Editor project has been evolving for more than 10 years and allows you to query any Database or Data Warehouse. Like previously described in the SQL Editor API post, all the end user functionalities and under the cover grunt work of integration can be simply reused programmatically (freeing up time to let you focus on the data work itself instead).…

5 minutes read - Version 4.11 / Development / Browsing

10 August 2021

Open In Importer and Copy Path Options in Filebrowser

We simplify object storage and DW integration. Now you can create a table from filebrowser, just select a file and click the “Open in Importer” option and also you can copy the path of a file by clicking the “Copy Path” option in fileborwser. If you want to create a table then you can use either “Open in Importer” option or Importer directly but if you want a table from your SQL then just copy the path of a file as described above and use it in the editor.…

1 minute read - Version 4.11 / Development / Query

26 July 2021

Create SQL tables on the fly with zero clicks

Last month, we introduced creating a table from the local file using importer. Previously, creating a new table required you to set up a storage account such as HDFS, S3, or ADLS to upload data. The list of SQL dialects was also restrictive, with no support for Apache Phoenix. Now, creating a table is even easier. Just drag and drop a CSV file on the table listing, and Hue automatically creates a SQL table for you!…

1 minute read - Version 4.11 / Development / Query

30 June 2021

Azure Storage sharing by leveraging SAS tokens so that your users don’t need credentials

Example tutorial on how to use the the Azure storage REST API with Shared Access Signatures. We previously covered a similar methodology for providing access to S3 data without giving out actual credentials via some S3 signed URLs. This time we will explore it on Azure, the Cloud data platform from Microsoft. “Trying to” keep things simple for the end users The main use case for us is still to provide a platform agnostic File Browser for the Hue users to allow self service data querying.…

4 minutes read - Version 4.11 / Development

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