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.
Signature
DISTINCTCOUNTHLL(colName, log2m)
Usage Examples
These examples are based on the Batch Quick Start.
select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats 
value
158
select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats 
value
149

value
158

value
149

DISTINCTCOUNTHLLMV

DISTINCTCOUNTBITMAPMV

Last modified 1yr ago