clickhouse SimpleAggregateFunction Tuple

豆腐饭请

已于 2023-04-23 11:32:42 修改

阅读量487

点赞数

文章标签： clickhouse java 数据库

于 2023-04-21 11:38:40 首次发布

本文链接：https://blog.youkuaiyun.com/qq_31349333/article/details/130284703

版权

创建表：
CREATE TABLE simpleAggregateFunction_test (
id String,
col1 SimpleAggregateFunction(sum, UInt64),
col2 SimpleAggregateFunction(groupUniqArrayArray, Array(Tuple(UInt32,String)))
) ENGINE = AggregatingMergeTree
order by (id);
插入数据：
INSERT INTO simpleAggregateFunction_test select ‘111’,toUInt64(100), [(1,‘xxx1’)];
INSERT INTO simpleAggregateFunction_test select ‘111’,toUInt64(200), [(2,‘xxx2’)];
INSERT INTO simpleAggregateFunction_test select ‘111’,toUInt64(50), [(2,‘xxx2’)];
INSERT INTO simpleAggregateFunction_test select ‘111’,toUInt64(50), [(3,‘xxx2’)];

查询
optimize table simpleAggregateFunction_test final;
select * ,arraySum(item -> item.1,col2) as rs from simpleAggregateFunction_test;

结果：
id |col1|col2 |rs|
—±—±---------------------------------±-+
111|400 |[(3,‘xxx2’),(2,‘xxx2’),(1,‘xxx1’)]| 6|