Hue consists in 4 apps in a single page interface that allow the users to perform data analyses without losing any context. The goal is to promote self service and stay simple like Excel so that 80% of the user can find, explore and query data and become more data driven.
1. Find or import your data
Use the left metadata assists to browse your existing data without losing your editor. The top search will look through your saved queries and matching tables, columns and databases. Objects can be tagged for a quick retrieval or assigning a more “humane” name. If the data does not exist yet, just drag & drop it to trigger the Create Table wizard and to import it in just two steps.
2. Query your data
When you found your data, the Editor’s autocomplete is extremely powerful as they support 90-100% of the language syntax and will highlight any syntax or logical error. The right assistant provides quick previews of the datasets, which columns or JOINs are popular and recommendations on how to type optimized queries. After the querying, refine your results before exporting to S3/HDFS/ADLS or downloaded as CSV/Excel.
3. 4 applications
Each app of Hue can be extended to support your own languages or apps as detailed in the developer guide.
The layout simplifies the interface and is a snappy single page app.
From top to bottom we have:
Learn more on the The Hue 4 user interface in detail.
Have you ever struggled to remember table names related to your project? Does it take much too long to find those columns or views? Hue now lets you easily search for any table, view, or column across all databases in the cluster. With the ability to search across tens of thousands of tables, you’re able to quickly find the tables that are relevant for your needs for faster data discovery.
The new search bar is always accessible on the top of screen, and it offers a document search and metadata search too if Hue is configured to access a metadata server.
Existing tags and indexed objects show up automatically, any additional tags you add appear back in metadata server, and the familiar metadata server search syntax is supported.
By default, only tables and views are returned. To search for columns, partitions, databases use the ‘type:’ filter.
Example of searches:
bof the table
web_logsin the database
Learn more on the Tagging.
In addition, you can also now tag objects with names to better categorize them and group them to different projects. These tags are searchable, expediting the exploration process through easier, more intuitive discovery.
Data where you need it when you need it.
Find your documents, HDFS and S3 files and more in the left assist panel, right-clicking items will show a list of actions, you can also drag-and-drop a file to get the path in your editor and more.
This assistant content depends on the context of the application selected and will display the current tables or available UDFs.
This popup offers a quick way to see sample of the data and other statistics on databases, tables, and columns. You can open the popup from the SQL Assist or with a right-click on any SQL object (table, column, function…). In this release, it also opens faster and caches the data.
Similarly to Google Documents, any document (e.g. SQL Query, Workflow, Dashboard…) opened in the Hue apps can be saved.
Sharing happens on the main page or via the top right menu of the selected application.
Two types of sharing permissions exist:
Shared documents will show-up with a little blue icon in the homepage.
Via the Home page, saved documents can be exported for backups or transferring to another Hue.
The language is automatically detected from the Browser or OS. English, Spanish, French, German, Korean, Japanese and Chinese are supported.
The language can be manual set by a user in the “My Profile” page. Please go to My Profile > Step2 Profile and Groups > Language Preference and choose the language you want.