Submitting queries with Hue

You can write and edit queries for Impala data marts using the query editor.

The first time you launch Hue from the options menu on an Impala Virtual Warehouse, you must set your username and password. Remember your credentials because they become your Hue superuser credentials, which you will need to use Hue again.

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

note
You can also launch Hue from the Virtual Warehouse page using the same steps.
On the Overview page under Virtual Warehouses, click the options menu for an Impala data mart and select Open Hue:
Log in to Hue and in the Hue left menu under Sources, click Impala to view the available Databases:

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