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.
column– The column name.
Take the OnTime data set and select any frequently occurring value in the
SELECT anyHeavy(AirlineID) AS res FROM ontime
┌───res─┐ │ 19690 │ └───────┘