Skip to main content
Skip to main content

STATE

STATE​

description​

Syntax​

AGGREGATE_FUNCTION_STATE(arg...) Returns the intermediate result of the aggregation function, which can be used for subsequent aggregation or to obtain the actual calculation result through the merge combiner, or can be directly written into the agg_state type table and saved. The type of the result is agg_state, and the function signature in agg_state is AGGREGATE_FUNCTION(arg...).

example​

mysql [test]>select avg_merge(t) from (select avg_union(avg_state(1)) as t from d_table group by k1)p;
+----------------+
| avg_merge(`t`) |
+----------------+
| 1 |
+----------------+

keywords​

AGG_STATE,STATE