Skip to content
Product
DBaaS
Service-Specific
ClickHouse
Reference
Supported table engines in Managed ClickHouse®

Supported table engines in Managed ClickHouse®

Table engines define how data is stored and which queries a table supports. Managed ClickHouse® supports different table engines depending on the service version. Engine availability can differ from upstream depending on features enabled in Managed ClickHouse®.

For details about each engine, see the ClickHouse documentation. For database engines, see Supported database engines.

Note

To support high availability and node replacement operations on the Exoscale platform, some table engines are automatically remapped. Every database you create with SQL uses the Replicated engine, so the remap always applies: MergeTree engines are silently replaced with their corresponding ReplicatedMergeTree variants, including on single-node services where there is only one replica.

MergeTree family

EngineReplicated variantSupported in
MergeTree (remapped)ReplicatedMergeTree25.3, 25.8
AggregatingMergeTree (remapped)ReplicatedAggregatingMergeTree25.3, 25.8
CoalescingMergeTree (remapped)ReplicatedCoalescingMergeTree25.8
CollapsingMergeTree (remapped)ReplicatedCollapsingMergeTree25.3, 25.8
GraphiteMergeTree (remapped)ReplicatedGraphiteMergeTree25.3, 25.8
ReplacingMergeTree (remapped)ReplicatedReplacingMergeTree25.3, 25.8
SummingMergeTree (remapped)ReplicatedSummingMergeTree25.3, 25.8
VersionedCollapsingMergeTree (remapped)ReplicatedVersionedCollapsingMergeTree25.3, 25.8

Integration engines

EngineSupported in
AzureBlobStorage25.3, 25.8
AzureQueue25.3, 25.8
COSN25.3, 25.8
GCS25.8
Kafka (cannot be created via SQL)25.3, 25.8
MaterializedPostgreSQL25.3, 25.8
MySQL25.3, 25.8
OSS25.3, 25.8
PostgreSQL25.3, 25.8
S325.3, 25.8
S3Queue25.3, 25.8
URL25.3, 25.8

Data lake engines

EngineSupported in
DeltaLake25.3, 25.8
DeltaLakeAzure25.8
DeltaLakeS325.8
Hudi25.3, 25.8
Iceberg25.3, 25.8
IcebergAzure25.3, 25.8
IcebergS325.3, 25.8

View engines

EngineSupported in
LiveView25.3, 25.8
MaterializedView25.3, 25.8
View25.3, 25.8
WindowView25.3, 25.8

Special-purpose engines

EngineSupported in
Buffer25.3, 25.8
Dictionary25.3, 25.8
Distributed25.3, 25.8
Join25.3, 25.8
KeeperMap25.3, 25.8
Memory25.3, 25.8
Merge25.3, 25.8
Null25.3, 25.8
Set25.3, 25.8

Testing and utility engines

EngineSupported in
FuzzJSON25.3, 25.8
FuzzQuery25.3, 25.8
GenerateRandom25.3, 25.8
Loop (cannot be created via SQL, use the loop table function)25.3, 25.8
Last updated on
Interfaces and drivers supported in Managed ClickHouse®Table functions supported in Managed ClickHouse®