Prerequisites
To get started in Cloudera Data Warehouse, your data must conform to supported compression codecs, and you must obtain Cloudera resource roles to grant users access to an environment. Users can then get started on tasks, such as activating the environment from Cloudera Data Warehouse.
Unsupported compression
Cloudera Data Warehouse does not support LZO compression due to licensing of the LZO library. You cannot query tables having LZO compression in Virtual Warehouses, which use Cloudera Data Warehouse Impala or Hive LLAP engines.
Cloudera resource roles
- DWAdmin: This role enables users or groups to grant a Cloudera user or group the ability to activate, terminate, launch, stop, or update services in Virtual Warehouses.
- DWUser: This role enables users or groups to view and use Cloudera Data Warehouse clusters (Virtual Warehouses) that are associated with specific environments.
A Cloudera PowerUser assigns these roles to users who require access to the Virtual Warehouses that are associated with specific environments. A default Database Catalog is associated with your environment. After granting these roles to users and groups, they then have Single Sign-On (SSO) access to the Virtual Warehouses.