Querying data in Cloudera Data Warehouse

This topic describes how to query data in your Virtual Warehouse on Cloudera Data Warehouse (CDW).

The CDW service includes SQL editors that you can use to submit queries to Virtual Warehouses. For example, you can use Hue to submit queries to an Impala Virtual Warehouse, and you can use Data Analytics Studio (DAS) to submit queries to a Hive Virtual Warehouse.
  1. Log in to the CDP web interface and navigate to the Data Warehouse service.
  2. In the Data Warehouse service, navigate to the Overview page.
  3. On the Overview page under Virtual Warehouses, click the options menu for one of the Virtual Warehouses, and click Open Hue for Impala or Open DAS for Hive warehouses:

  4. Enter your query into the editor and submit it to the Virtual Warehouse.