Unified Analytics basics

A brief description Unified Analytics engines and query editors prepares you to run a query. You learn how to select the SQL engine that best suits your needs.

In Cloudera Data Warehouse (CDW) Public Cloud, Unified Analytics integrates essential warehouse software:

  • SQL engines: Hive and Impala
  • Query editors: Hue and the Impala shell

You typically create a Hive Virtual Warehouse for a data-intensive process, such as ETL. For BI and ad hoc queries, you typically create an Impala Virtual Warehouse.

As DW Admin, you use a one- or two-step procedure to create a Virtual Warehouse (VW) for querying your data, as shown in the following diagram:

When you create a Hive Virtual Warehouse, Unified Analytics is enabled. When you create an Impala Virtual Warehouse, you need to perform an extra step to enable Unified Analytics.