distinctCountHllPlusMv

This section contains reference documentation for the DISTINCTCOUNTHLLPLUSMV function.

Returns an approximate distinct count using HyperLogLogPlusPlus in a group. The optional parameter p defines the normal set precision and the parameter sp defines the sparse set precision.

Signature

DISTINCTCOUNTHLLPLUSMV(colName) DISTINCTCOUNTHLLPLUSMV(colName, p) DISTINCTCOUNTHLLPLUSMV(colName, p, sp)

Usage Examples

These examples are based on the Hybrid Quick Start.

select DISTINCTCOUNTHLLPLUSMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

value
34