Apache Pinot Docs
Search…
latest
Configuration Reference
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.
1
select DISTINCTCOUNTHLL(teamID) AS value
2
from baseballStats
Copied!
value
158
1
select DISTINCTCOUNTHLL(teamID, 12) AS value
2
from baseballStats
Copied!
value
149
Copy link