MERGE

SinceVersion 2.0.0

description

Syntax

AGGREGATE_FUNCTION_MERGE(agg_state) 将聚合中间结果进行聚合并计算获得实际结果。 结果的类型与AGGREGATE_FUNCTION一致。

example

1. mysql [test]>select avg_merge(avg_state(1)) from d_table;
2. +-------------------------+
3. | avg_merge(avg_state(1)) |
4. +-------------------------+
5. |                       1 |
6. +-------------------------+

keywords

AGG_STATE, MERGE