表格存储服务 CLOUDTABLE-ClickHouse表引擎概述:AggregatingMergeTree

时间：2025-03-06 17:28:46

AggregatingMergeTree

AggregatingMergeTree表引擎也是预先聚合引擎的一种，用于提升聚合计算的性能。

建表语句。

CREATE TABLE [IF NOT EXISTS] [db.]table_name [ON CLUSTER ClickHouse集群名]
(
    name1 [type1] [DEFAULT|MATERIALIZED|ALIAS expr1],
    name2 [type2] [DEFAULT|MATERIALIZED|ALIAS expr2],
    ...
) ENGINE = AggregatingMergeTree()
[PARTITION BY expr]
[ORDER BY expr]
[SAMPLE BY expr]
[TTL expr]
[SETTINGS name=value, ...]

上一篇：表格存储服务 CLOUDTABLE-ClickHouse表引擎概述:SummingMergeTree

下一篇：表格存储服务 CLOUDTABLE-ClickHouse表引擎概述:Replicated*MergeTree引擎