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
- Review the requirements and plan your deployment.
- Activate an environment on OpenShift or Embedded Container Service.
- Create your first Virtual Warehouse and run a query in Cloudera Data Explorer (Hue).
- Connect BI tools and clients.
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.
