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.