AggregateFunction

AggregateFunction column type cannot be queried (or inserted to) directly. To insert into an AggregateFunction column, special functions with suffix ..State are required, like: uniqState, maxState, argMaxState.

Likewise, it's not possible to select directly from such column. To select, a function with ..Merge suffix is required: uniqMerge, maxMerge, argMaxState etc. This is limitation by ClickHouse itself (i.e. you can't select from a table containing AggregateFunction column into CSV or JSON format without getting invalid results)

Given a table with schema:

CREATE TABLE t (
    c AggregateFunction(uniq, Int8)
) ENGINE = Memory

The correct way to select from it would be:

SELECT uniqMerge(c) FROM t