Articles & News

11 March 2020

Automatically checking documentation and website dead links with Continuous Integration

Hi Data Crunchers, Continuous integration and automation are investment that enable a major scaling in the resource and quality of software projects. This past year saw a lot of improvements with an integrated commit flow and adding series of checks like linting of JavaScript, also running Python 3 tests automatically… This also create a virtuous circle that encourages developers to add more tests on their own (e.g. +200 since the beginning of this year), as all the plumbing is already done for them.…

1 minute read - Administration / Version 4.7

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.7 / Querying

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.7 / Querying / 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.7 / Querying

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.7 / Querying

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 and the content of 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 / Querying

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 - Querying / 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 - Browsing / Version 4

17 October 2019

Easily checking for deadlinks on 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 - Administration / Version 4

More recent stories

17 November 2020
Easy Querying of live Kafka data in a Big Table like HBase with SQL
Read More
20 October 2020
Tutorial on querying live streams of data with Flink SQL
Read More
20 October 2020
Tutorial on querying live streams of data with ksql (Kafka SQL)
Read More