UNION

SinceVersion 2.0.0

description

Syntax

AGGREGATE_FUNCTION_UNION(agg_state) Aggregate multiple aggregation intermediate results into one. The type of the result is agg_state, and the function signature is consistent with the input parameter.

example

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

keywords

AGG_STATE, UNION