clickhouse引擎--SummingMergeTree引擎

最新推荐文章于 2024-05-21 14:52:28 发布

小陈菜奈-

最新推荐文章于 2024-05-21 14:52:28 发布

阅读量177

点赞数

分类专栏： Clickhouse 文章标签： database

本文链接：https://blog.csdn.net/nayomi927/article/details/120131039

版权

Clickhouse 专栏收录该内容

23 篇文章 2 订阅

订阅专栏

SummingMergeTree引擎

SummingMergeTree引擎用于求和

create table sum_tree(
id String,
city String,
sal UInt32,
comm Float64,
time DateTime
)engine=SummingMergeTree()
partition by toDate(time)
primary key id
order by(id,city);

insert into sum_tree values
(1,'shanghai',10,20,'2021-08-31 01:11:12'),
(1,'shanghai',20,30,'2021-08-31 02:11:12'),
(2,'shanghai',30,40,'2021-07-31 01:11:12'),
(2,'beijing',40,50,'2021-07-31 01:11:12');
select * from sum_tree;      //自动将数值类型的字段进行了求和
┌─id─┬─city─────┬─sal─┬─comm─┬────────────────time─┐
│ 2  │ beijing  │  40 │   50 │ 2021-07-31 01:11:12 │
│ 2  │ shanghai │  30 │   40 │ 2021-07-31 01:11:12 │
└────┴──────────┴─────┴──────┴─────────────────────┘
┌─id─┬─city─────┬─sal─┬─comm─┬────────────────time─┐
│ 1  │ shanghai │  30 │   50 │ 2021-08-31 01:11:12 │
└────┴──────────┴─────┴──────┴─────────────────────┘


create table sum_tree1(
id String,
city String,
sal UInt32,
comm Float64,
time DateTime
)engine=SummingMergeTree(sal)
partition by toDate(time)
primary key id
order by(id,city);

insert into sum_tree1 values
(1,'shanghai',10,20,'2021-08-31 01:11:12'),
(1,'shanghai',20,30,'2021-08-31 02:11:12');
select * from sum_tree1;     //指定字段进行求和
┌─id─┬─city─────┬─sal─┬─comm─┬────────────────time─┐
│ 1  │ shanghai │  30 │   20 │ 2021-08-31 01:11:12 │
└────┴──────────┴─────┴──────┴─────────────────────┘