16 January 2018

Intuitively discovering and exploring a Wine dataset with the Dynamic Dashboards

Dashboards are an easy way to quickly explore a new dataset without typing any SQL. It usually complements the analyses before or after the querying activity in the SQL Editor. In this scenario we are using Apache Solr as the analytic database backend. Goal: we are picking a Wine dataset from the Machine Learning Competition website Kaggle and want to get a feeling of the industry and select some good wines similar to one of our best ranked favorite Pink / “Rosé” wine.…

2 minutes read - Version 4

10 January 2018

Self Service BI: doing a Customer 360 by querying and joining Salesforce, Marketing and log datasets

In this demo we use the Editor to query credit card transaction data that is saved in an object store in the cloud (here S3) and in a Kudu table. The demos leverages the Data Catalog search and tagging as well as the Query Assistant. Note: Do it Yourself! The queries and data are freely available on demo.gethue.com. Scenario: Digital Services International You recently launched a new streaming service: VP wants to understand support impact of this launch Marketing wants to use this to better target campaigns Goal: Build a 360-degree view of your customers to understand the support costs, product usage, time-to-resolution, and current activity in marketing channels…

1 minute read - Version 4 / Tutorial

05 January 2018

Import data to be queried via the Self Service Drag & Drop Create Table Wizard

Create table wizard If you’ve ever struggled with creating new SQL tables from files, you’ll be happy to learn that this is now much easier. With the latest Hue release, you can now create these in an ad hoc way and thereby expedite self-service analytics. The wizard has been revamped to two simple steps and also offers more formats. Now users just need to: Select a file Select the type of table And that’s it!…

1 minute read - Version 4

04 January 2018

How to optimally configure your Analytic Database for High Availability with Hue and other SQL clients

Hi Big Data Explorers, HiveServer2 and Impala support High Availability through a “load balancer”. One caveat is that Hue's underlying Thrift libraries reuse TCP connections in a pool, a single user session may not have the same Impala or Hive TCP connection. If a TCP connection is balanced away from the previously selected HiveServer2 or Impalad instance, the user session and its queries can be lost and trigger the “Results have expired” or “Invalid session Id” errors.…

4 minutes read - Version 4

13 December 2017

Using Hue to interact with Apache Kylin in your cluster or on AWS

This is a blog post from the community by Joanna He and Yongjie Zhao. What is Apache Kylin Apache Kylin is a leading open-source online analytical processing (OLAP) engine that’s built for interactive analytics for Big Data. It provides an ANSI-SQL interface and multi-dimensional OLAP for massive datasets. It supports consuming data in batch and streaming and offers sub-second query latency on petabyte-scale dataset. It seamlessly integrates with BI tools via ODBC driver, JDBC driver, and REST API.…

4 minutes read - Version 4

08 December 2017

Browsing Impala Query Execution within the SQL Editor

Greetings SQL aficionados! In Hue 4.2, along with ADLS support, we're introducing a new feature that is sure to make query troubleshooting easier: Impala query execution details right inside of the SQL Editor.  There are three ways to access the new browser: Best: Click on the query ID after executing a SQL query in the editor. This will open the mini job browser overlay at the current query. Having the query execution information side by side the SQL editor is especially helpful to understand the performance characteristics of your queries.…

2 minutes read - Version 4

20 November 2017

Browsing ADLS data, querying it with SQL and exporting the results back in Hue 4.2

We’re happy to present Microsoft Azure Data Lake Store (ADLS) integration in Hue with Hue 4.2 release. Similarly to the S3 integration, Hue can be setup to read and write to a configured ADLS, and users can directly query from and save data to ADLS without any intermediate moving / copying to HDFS. For a detailed video walkthrough of file manipulation using ADLS in Hue, have a look: In case you missed the one for S3, here is the link to the post.…

4 minutes read - Version 4

04 October 2017

Hue 4.1 is out!

Hi Big Data Explorers,  The Hue Team is glad to thanks all the contributors and release Hue 4.1!  The focus of this release was to keep making progress on the modernization and simplification of the Hue 4 UI without introducing any major feature. The SQL editor is smarter and the ground for better speed and visualizations was prepared (coming in the next release). This release is more of a “quality/transition” with 900 commits and 250+ bug fixes!…

2 minutes read - Release

24 August 2017

Importing data from traditional databases into HDFS/Hive in just a few clicks

There are exciting new features coming in Hue 4.1 and later in CDH 6 next year. One of which is Hue’s brand new tool to import data from relational databases to HDFS file or Hive table using Apache Sqoop 1. It enables us to bring large amount of data into the cluster in just few clicks via interactive UI. This Sqoop connector was added to the existing import data wizard of Hue.…

5 minutes read - Version 4 / Tutorial

20 July 2017

The Hue 4 user interface in detail

Aloha User Experience enthusiasts, With the Hue 4 release we introduced a modern UI on top of our existing software to facilitate data discovery and analysis on premise and in the cloud. The new UI organization The new layout simplifies the interface and is now single page app, and this makes things snappier and unifies the apps together. From top to bottom we have: A completely redesigned top bar, with a quick action (big blue button), a global search and a notification area on the right A collapsible hamburger menu that offers links to the various apps and a quick way to import data An extended quick browse on the left The main app area, where the fun is 🙂 A right Assistant panel for the current application.…

3 minutes read - Version 4