Skip to main content

Supported table engines in Aiven for ClickHouse®

Table engines define how data is stored and which queries a table supports. Aiven for ClickHouse® supports different table engines depending on the service version. Engine availability can differ from upstream depending on features enabled in Aiven for 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 Aiven platform, some table engines are automatically remapped. In replicated databases, MergeTree engines are replaced with their corresponding ReplicatedMergeTree variants.

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 (via integration only, not via SQL)25.3, 25.8
MaterializedPostgreSQL25.3, 25.8
MySQL25.3, 25.8
OSS25.3, 25.8
PostgreSQL (via SQL or integration)25.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
Loop25.3, 25.8
tip

Managed credentials integrations simplify authentication for integration engines and dictionaries that access remote sources. Enable them when using these engines. Learn how to enable managed credentials.