Skip to Content
Product IntroductionWhat is Cloud Data Warehouse UClickHouse

What is UClickHouse Cloud Data Warehouse

UClickHouse Cloud Data Warehouse provides a comprehensive, secure, stable, and reliable managed service for the open-source columnar database management system, ClickHouse. It is optimized for data and hardware of varying scales, offering additional convenient tool support. This way, you can use the ClickHouse service without worrying about cluster configuration, selection, failure, maintenance, development tools, and more. You can conveniently purchase UClickhouse on UCloud Global and have a private Clickhouse cluster.

Product Architecture

UClickhouse is designed as a Clickhouse cluster + Zookeeper cluster, with the following specific features:

  • Zookeeper cluster and Clickhouse cluster are deployed separately on different cloud hosts.

  • Zookeeper is designed as a three-node cluster, and Clickhouse is designed as a single cluster with multiple shards and dual replica structure.

  • Each replica (node) is deployed on a separate cloud host, with each cloud host providing only one shard’s replica service.

Product Features

Key features include:

  • Naturally supports column-oriented data compression with a high data compression ratio.
  • Multi-core parallel processing allows for the natural parallelization of large queries, utilizing all necessary available resources on the current server.
  • Vectorized computing engine processes data not only by columns but also by vectors (part of a column) for high CPU efficiency.
  • Data replication and integrity support use asynchronous multi-master replication, where all remaining replicas will retrieve their copies in the background after writing to any available replica.
  • SQL support with a SQL-based declarative query language, which in many cases aligns with the ANSI SQL standard.
  • Adaptive Join Algorithm.

For the ClickHouse official site, please visit https://clickhouse.com

For ClickHouse reference documentation, please visit https://clickhouse.com/docs/zh

Enhanced Features

UClickhouse provides the following enhancements for enterprise users:

  • Visualization Monitoring: Memory, CPU, disk monitoring, etc.

  • Scalability: Supports multiple specification configurations and elastic vertical scaling.