04 March 2020

A better collaborative Data Warehouse Experience with SQL query sharing via links or gists

Hi Data Crunchers, For the past 10 years, Hue's SQL Editor has been targeting the SQL Data Warehouse Experience. It recently got better support for typing SQL queries by showing column keys. The latest improvement is about better collaboration. Via the document sharing capabilities and query parameterization, Hue allows teams to build their own query bank of knowledge. To complement this, something quicker and easier is now also available: Public link & Gist sharing.…

2 minutes read - Version 4

27 February 2020

Re-using the JavaScript SQL Parser

SQL autocompletion The parser is running on the client side and comes with just a few megabytes of JavaScript that are then cached by the browser. This provides a very reactive & rich experience to the end users and allows to import it as a module dependency. While the dynamic content like the list of tables, columns.. is obviously fetched via remote endpoints, all the SQL knowledge of the statements is available.…

3 minutes read - Version 4 / Development

10 February 2020

The Hue SQL Query Experience for your Data Warehouse

Hue has just blown its 10th candle! In this follow-up #2 of the series, let's describe what a SQL Cloud Editor is. The top two capabilities of a SQL Cloud Editor are: Data Querying Experience: offer a SQL querying assistant that helps users self service their own query need while educating them on the data and syntax know-how. Cloud Native: scale by providing as much as “no-ops” as possible by automating the operation of the service.…

12 minutes read - Version 4

28 January 2020

10 years of Data Querying Experience Evolution with Hue

Hue has just blown its 10th candle. Hue was created when Apache Hadoop was still in its infancy before becoming mainstream (read more about the Hadoop story in Hadoop is Dead. Long live Hadoop). Hue originally was a part of Cloudera Manager, which was proprietary and focused more on the administrators but was then moved out to its own open source project in version 0.3. Hue then gradually evolved from being a desktop like application to a modern single page SQL Editor (and is at version 4.…

3 minutes read - Version 4

05 December 2019

Hue 4.6 and its improvements are out!

Hi Data Explorers,  The Hue Team is glad to thanks all the contributors and release Hue 4.6!  The focus of this release was to keep building on top of 4.5 and modularize the tech stack, improve SQL integrations and prepare major upcoming features of Hue 5. In particular now: Python 3 support can be tested There is a new version of gethue.com and the content of docs.gethue.com was revamped The new version of the Editor with multi execution contexts and more robustness is 66% done Build your own or improve SQL parsers with highlighter This release comes with 650+ commits and 100+ bug fixes!…

3 minutes read - Version 4 / Release

13 November 2019

Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types

Hi SQL crunchers, The Datawarehouse ecosystem with Apache Hive and Apache Impala is getting more complete with the introduction of transactions. In practice, this means your tables can now support Primary Keys, INSERTs, DELETEs and UPDATEs as well as Partition Keys. Here is a tutorial demoing how Hue's SQL Editor helps you quickly visualize and use these instructions via its assists and autocomplete components. Primary Keys Primary Keys shows up like Partition Keys with the lock icon:…

3 minutes read - Version 4

31 October 2019

Missing some color? How to improve or add your own SQL syntax Highlighter

Hue’s Editor SQL functionalities makes it much more easier to query your databases and datawarehouses. It was previously described about how to improve or create your own SQL autocompleter so that the Querying Experience gets even more effective. This post is about going one step further and improving the SQL syntax highlighting. New keywords might not be properly colored highlighted in the editor. This is especially true when adding a new language.…

2 minutes read - Version 4

24 October 2019

How to create a HBase table on Kerberized Hadoop clusters

Hi SQL Data Explorers, If you are using HBase with Hue on CDH6.1.x or later, you may find Hue’s check configuration fails for HBase with following error: Failed to authenticate to HBase Thrift Server, check authentication configurations. With change from HBase(HBASE-19852), we have to configure HBase properly through Cloudera Manager with following steps to enable Hue-Hbase communication. Step 1 Navigate to CM->Clusters->HBASE-1->Configurations, search for “thrift” and verify the “Enable HBase Thrift Http Server” and “Enable HBase Thrift Proxy Users” are checked, and “Enable HBase Thrift Server Compact Protocol” and “Enable HBase Thrift Server Framed Transport” are unchecked.…

2 minutes read - Version 4

17 October 2019

Easily checking for deadlinks on docs.gethue.com

docs.gethue.com are getting some refreshed content continuously. In addition, a series of links not working (returning a 404) have been fixed. Here is how it was done. First we used the muffet tool. muffet is a fast link checker crawler, very easy to use: sudo snap install muffet Then after booting the hugo documentation server, we point to its url. We also blacklist certain urls to avoid some noisy false positives:…

2 minutes read - Version 4

10 October 2019

Integration with Microsoft Azure Data Lake Store Gen2

Hue continues its progress to make the Cloud platforms easier to use. We’re happy to preset compatibility with Microsoft Azure Data Lake Store Gen2 (ADLS Gen2). Hue 4.6 release brings the ability to read and write from a configured ADLS Gen2. Almost like ADLS, users can save data to ADLS Gen2 without copying or moving to HDFS. The difference between ADLS Gen1 and Gen2 is that ADLS Gen2 does not rely on the HDFS driver.…

3 minutes read - Version 4