minIf on aggregatingMergeTree

[jakesylvestre]

Hi,

I'm trying to use minIf on a state for insertion into an aggregating merge tree and am a bit confused by the documentation. So let's say I have the following table

CREATE TABLE IF NOT EXISTS example
(
    `first_sent` AggregateFunction(minIf, UInt32, UInt8),
)
ENGINE = AggregatingMergeTree()
ORDER BY (first_sent)

I want to insert into first_sent using the state. If this were a regular min, I could use minState(column). But I can't find any documented way to do this with state.

[jakesylvestre]

Figured this out as I was writing the question.

*ifState is a function (that's the meaning of any in the documentation) so minIfState and maxIfState will work ehre.