anyHeavy

Introduced in: v1.1.0 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’s execution threads, this value is returned. Normally, the result is nondeterministic. Syntax

anyHeavy(column)

Arguments

column — The column name. String

Returned value Returns a frequently occurring value. The result is nondeterministic. Any Examples Usage example

Query

SELECT anyHeavy(AirlineID) AS res
FROM ontime;

Response

┌───res─┐
│ 19690 │
└───────┘

​anyHeavy

anyHeavy