Apache Hue

What Apache Hue is

Apache Hue is an open-source SQL assistant for databases and data warehouses, with a SQL Editor, Notebook mode, and dashboards. The editor offers autocomplete, risk alerts, and self-service troubleshooting. Query results can be charted or exported as CSV or XLS, sent to cluster storage, or saved to a table. Notebook mode supports light programming snippets, while dashboards visualize indexed data and query SQL databases. Documented connectors include Hive, Impala, Presto, Flink SQL, Spark SQL, PostgreSQL, Redshift, BigQuery, and Snowflake, among others. Table and storage browsers use existing data catalog knowledge to help people find data across databases. Queries can be shared with permissions, and administrators configure database and warehouse connectors for users. The site describes a Slack app for query assistance, rich link previews, and sharing from the Editor. Deployment instructions cover Docker and Helm on Kubernetes; listed distributions include Cloudera Data Platform, AWS EMR, Google Cloud Dataproc, Azure HDInsight, and Open Data Hub. Documentation describes SAML single sign-on, HTTPS configuration, and a REST API. Hue is free under the Apache License 2.0 and uses self-hosted installation.

Who it suits

Hue suits people who need a SQL workspace across supported databases and data warehouses. It may fit teams that want query sharing, notebooks, or self-hosted deployment.

Getting started

1. Visit https://gethue.com/.
2. Choose a self-hosted deployment route: run Hue with Docker or install it through Helm on Kubernetes.
3. Have an administrator configure database and warehouse connectors for users.
4. Use the SQL Editor to query connected data.

Verdict

Hue brings SQL editing, result handling, and data discovery into a self-hosted open-source tool. Check that its documented connectors and deployment options match your environment.