Accessing and using Cloudera Data Explorer (Hue) in Cloudera Data Warehouse

Get started using Data Explorer by analyzing and visualizing your data with Impala and Hive SQL query engines.

To try Data Explorer without having an account, try running sample queries on http://demo.gethue.com/.

Data Explorer uses your LDAP credentials that you have configured for the Cloudera cluster.

Log into the Cloudera web interface and navigate to the Cloudera Data Warehouse service.
In the Cloudera Data Warehouse service, navigate to the Overview page.

note
You can also launch Data Explorer from the Virtual Warehouse page using the same steps.
To run Impala queries:
1. On the Overview page under Virtual Warehouses, click on the Data Explorer (Hue) button.
  The query editor is displayed:
2. Click a database to view the tables it contains.
  When you click a database, it sets it as the target of your query in the main query editor panel.
3. Type a query in the editor panel and click the run icon to run the query.
  
  note
  Use the Impala language reference to get information about syntax in addition to the SQL auto-complete feature that is built in. To view the language reference, click the book icon to the right of the query editor panel.
To run Hive queries:
1. On the Overview page under Virtual Warehouses, click on the Data Explorer (Hue) button.
  The Hive query editor is displayed:
2. Click a database to view the tables it contains.
  When you click a database, it sets it as the target of your query in the main query editor panel.
3. Type a query in the editor panel and click the run icon to run the query.
  
  note
  Use the Hive language reference to get information about syntax in addition to the SQL auto-complete feature that is built in. To view the language reference, click the book icon to the right of the query editor panel.