# 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](https://docs.pinot.apache.org/start-here/quick-start#hybrid).

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

| value |
| ----- |
| 34    |