Comment on page
DISTINCTCOUNTHLL
This section contains reference documentation for the DISTINCTCOUNTHLL function.
Returns an approximate distinct count using HyperLogLog. It also takes an optional second argument to configure the log2m for the HyperLogLog.
For accurate distinct counting, see DISTINCTCOUNT.
DISTINCTCOUNTHLL(colName, log2m)
select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats
value |
---|
158 |
select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats
value |
---|
149 |
Last modified 1yr ago