# DISTINCTCOUNTRAWHLLPLUSMV

Returns HLLPlus response serialized as string. The serialized HLLPlus can be converted back into an HLLPlus and then aggregated with other HLLPluses. A common use case may be to merge HLLPlus responses from different Pinot tables, or to allow aggregation after client-side batching.\
The optional parameter *p* defines the normal set precision and the parameter *sp* defines the sparse set precision.

## Signature

> DISTINCTCOUNTRAWHLLPLUSMV(colName) DISTINCTCOUNTRAWHLLPLUSMV(colName, p) DISTINCTCOUNTRAWHLLPLUSMV(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 DISTINCTCOUNTRAWHLLPLUSMV(DivAirports) AS value
from airlineStats 
where arraylength(DivAirports) > 1
```

| value                                                                                                                                                                                                                                                                                                                                                                    |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 00000008000000ac00000000000000000000000500000020000000000030000202108000040000010000000300010400000000000000000000000463000000000000000000010001041000200000002000000000000000000a00000000028001000000010800000000010000001008000000804000000000020000040000880000000000000000000000000000000000000000000000800000000800020004000000840000000002000000000000000000001400 |

```sql
select DISTINCTCOUNTRAWHLLPLUSMV(DivAirports, 1) AS value
from airlineStats 
where arraylength(DivAirports) > 1
```

| value                    |
| ------------------------ |
| 0000000100000004000000e4 |