anyHeavy
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.
anyHeavy(column)
Arguments
column
β The column name.
Example
Take the OnTime data set and select any frequently occurring value in the AirlineID
column.
SELECT anyHeavy(AirlineID) AS res
FROM ontime
ββββresββ
β 19690 β
βββββββββ