ApsaraDB for ClickHouse is a fully managed, cloud-native Online Analytical Processing (OLAP) database service built on the open-source ClickHouse project. It delivers greater stability, security, and manageability than a self-managed ClickHouse deployment.
Video introduction
Why use the managed service
ApsaraDB for ClickHouse removes the operational burden of running ClickHouse yourself:
Fast setup: Easily provision and deploy ClickHouse clusters on Alibaba Cloud.
Built-in reliability: The service provides greater stability and manageability than running ClickHouse yourself.
Enterprise-grade security: Security controls are built into the service, reducing configuration work.
Simplified operations: Ongoing operational tasks are handled by the service, lowering administrative overhead.
Engine capabilities
ApsaraDB for ClickHouse is a column-oriented database designed for OLAP workloads. It supports SQL queries and performs aggregate analysis queries on wide tables an order of magnitude faster than other analytical databases. The underlying engine includes:
High data compression ratio: Column-oriented storage compresses data of the same type more efficiently, reducing storage costs and improving I/O throughput.
Multi-core parallel processing: Queries automatically distribute work across available CPU cores, accelerating large-scale aggregations.
Vectorized execution engine: The query engine processes data in batches using SIMD instructions, maximizing CPU efficiency.
Nested data structures: Native support for arrays and nested types allows complex data models without preprocessing.
Sparse indexes: Primary key indexes cover ranges of rows rather than individual rows, making them memory-efficient for sorted datasets.
For a deeper look at the underlying engine, see the official ClickHouse documentation and the ClickHouse project site.
Editions
ApsaraDB for ClickHouse is available in two editions:
Enterprise Edition: Offers advanced features for enterprise workloads.
Community-compatible Edition: Maintains compatibility with the open-source ClickHouse interface.
For a detailed feature comparison, see Differences between Enterprise Edition and Community-compatible Edition.
Next steps
Buy page: Select an edition and region to get started.
Differences between Enterprise Edition and Community-compatible Edition: Compare editions before provisioning.