Running a query in Cloudera Data Warehouse

You simply open Hue and submit your query. You do not need to manually start beeline or any other shell.

As a DWUser, you open Hue from a Virtual Warehouse that you set up, and run the query. The SQL engine reads from and writes to the same metastore, regardless of the type Virtual Warehouse.
  • Required role: DW User
  • You obtained permission to run SQL queries from the EnvironmentAdmin, who added you to a Hadoop SQL policy.
  1. Log into the Data Warehouse service as DWUser.
  2. Go to the Virtual Warehouses tab, locate the Virtual Warehouse using which you want to run queries, and click HUE.
    The Hue query editor opens in a new browser tab.
  3. To run a query:
    1. 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.
    2. Type a query in the editor panel and click to run the query.