https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anyheavy
anyHeavy | ClickHouse Docs
Selects a frequently occurring value using the heavy hitters algorithm. If there is a value that occurs more than in half the cases in each of the query...
clickhousedocs