arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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.

hashtag
Signature

DISTINCTCOUNTHLL(colName, log2m)

hashtag
Usage Examples

These examples are based on the .

value
value
select DISTINCTCOUNTHLL(teamID) AS value
from baseballStats 

158

149

Batch Quick Start
select DISTINCTCOUNTHLL(teamID, 12) AS value
from baseballStats