Cloudera Data Warehouse on Premises

Cloudera Data Warehouse on premises is a containerized analytics service that runs in your own data center on Red Hat OpenShift Container Platform or Cloudera Embedded Container Service. Powered by the Cloudera Data Warehouse Runtime, you deploy self-service data warehouses and data marts as isolated Virtual Warehouses running Hive, Impala, or Trino against the data and metadata in your Cloudera Base cluster. Virtual Warehouses provide dedicated, autoscaling compute so workloads do not compete for shared resources, and idle capacity is automatically released to optimize infrastructure costs.

Get started

SQL AI Assistant

The SQL AI Assistant in Cloudera Data Explorer (Hue) turns natural-language prompts into SQL, and can explain, optimize, and fix existing queries. You can connect it to a model hosted in Cloudera AI or to a supported third-party model provider.

Learn more about the SQL AI Assistant.

Enterprise analytics in your data center

Cloudera Data Warehouse on premises brings cloud-native elasticity to the data you already manage on premises:

  • Choice of query engines: Use Hive for large-scale batch and ETL workloads, Impala for low-latency interactive and BI queries, and Trino for federated queries across multiple data sources.
  • Workload isolation and autoscaling: Each Virtual Warehouse runs on its own compute. Hive concurrency autoscaling, Impala Workload Aware Auto-Scaling, and Trino auto-scaling match resources to demand, and auto-suspend releases idle resources.
  • Shared data and metadata: Database Catalogs connect every Virtual Warehouse to the same Hive Metastore and storage on your base cluster, including HDFS, Apache Ozone, and Apache Iceberg tables.
  • Query and connect: Write and run queries in Cloudera Data Explorer (Hue), or connect BI tools such as Tableau and command-line clients through JDBC.
  • Secure access: Authenticate users with LDAP or Kerberos, and secure communication between workload pods with mutual TLS (mTLS).

For details about the Hive, Impala, and Trino versions that Virtual Warehouses run, see Cloudera Data Warehouse Runtime.

What’s new

To learn about the latest features and improvements, see What’s new in Cloudera Data Warehouse on premises.