Skip to content

Latest commit

 

History

History
30 lines (22 loc) · 748 Bytes

distinctcounthllplusmv.md

File metadata and controls

30 lines (22 loc) · 748 Bytes
Raw
description
This section contains reference documentation for the DISTINCTCOUNTHLLPLUSMV function.

DISTINCTCOUNTHLLPLUSMV

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