1 of 1

DISTINCTCOUNTHLLMV

This section contains reference documentation for the DISTINCTCOUNTHLLMV function.

Returns an approximate distinct count using HyperLogLog in a group

Signature

DISTINCTCOUNTHLLMV(colName)

These examples are based on the Hybrid Quick Start.

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

value

This section contains reference documentation for the DISTINCTCOUNTHLLMV function.

Returns an approximate distinct count using HyperLogLog in a group

DISTINCTCOUNTHLLMV(colName)

These examples are based on the Hybrid Quick Start.

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

value