Supported table engines in Aiven for ClickHouse®

This article lists the table engines that are currently supported in Aiven for ClickHouse®.

ClickHouse® supports several table engines that define the storage parameters, supported queries, and other aspects of the data tables. For details on each table engine, see the ClickHouse documentation.

Note

To support node recycling for backup and restore procedures and high availability in the Aiven platform, some of the table engines are remapped. This means that in replicated databases, MergeTree engines are automatically replaced with ReplicatedMergeTree variants of the same engine.

Aiven for ClickHouse supports the following table engines:

Engine

Engine family

AggregatingMergeTree (remapped)

MergeTree

Buffer

Special engines

CollapsingMergeTree (remapped)

MergeTree

Dictionary

Special engines

Distributed

Special engines

GenerateRandom

Special engines

GraphiteMergeTree (remapped)

MergeTree

MaterializedView

Special engines

Memory

Special engines

Merge

Special engines

MergeTree (remapped)

MergeTree

Null

Special engines

ReplacingMergeTree (remapped)

MergeTree

ReplicatedAggregatingMergeTree (remapped)

MergeTree

ReplicatedCollapsingMergeTree

MergeTree

ReplicatedGraphiteMergeTree

MergeTree

ReplicatedMergeTree

MergeTree

ReplicatedReplacingMergeTree

MergeTree

ReplicatedSummingMergeTree

MergeTree

ReplicatedVersionedCollapsingMergeTree

MergeTree

Set

Special engines

SummingMergeTree (remapped)

MergeTree

VersionedCollapsingMergeTree (remapped)

MergeTree

View

Special engines