ReferenceSQL ReferenceAggregate Functions

retention

Takes a list of conditions (from 1 to 32) and, for each row group, returns an array of 0/1 values indicating whether the first condition and each subsequent condition were satisfied.

This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See SQL interface scope.

Takes a list of conditions (from 1 to 32) and, for each row group, returns an array of 0/1 values indicating whether the first condition and each subsequent condition were satisfied.