distinctCountHllPlus

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.

Signature

DISTINCTCOUNTHLLPlus(colName) DISTINCTCOUNTHLLPlus(colName, p) DISTINCTCOUNTHLLPlus(colName, p, sp)

Usage Examples

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