| description |
|---|
This section contains reference documentation for the DISTINCTCOUNTHLLPLUS function. |
Returns an approximate distinct count using HyperLogLogPlusPlus. It also takes an optional second and third arguments to configure the p, sp for the HyperLogLogPlus.
The optional parameter p defines the normal set precision and the parameter sp defines the sparse set precision.
For accurate distinct counting, see DISTINCTCOUNT.
DISTINCTCOUNTHLLPlus(colName) DISTINCTCOUNTHLLPlus(colName, p) DISTINCTCOUNTHLLPlus(colName, p, sp)
These examples are based on the Batch Quick Start.
select DISTINCTCOUNTHLLPLUS(teamID) AS value
from baseballStats | value |
|---|
| 158 |
select DISTINCTCOUNTHLLPLUS(teamID, 12) AS value
from baseballStats | value |
|---|
| 149 |