Skip to content

Latest commit

 

History

History
40 lines (30 loc) · 2.19 KB

distinctcountrawhllplusmv.md

File metadata and controls

40 lines (30 loc) · 2.19 KB
Raw
description
This section contains reference documentation for the DISTINCTCOUNTRAWHLLPLUSMV function.

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.

select DISTINCTCOUNTRAWHLLPLUSMV(DivAirports) AS value
from airlineStats 
where arraylength(DivAirports) > 1
value
00000008000000ac00000000000000000000000500000020000000000030000202108000040000010000000300010400000000000000000000000463000000000000000000010001041000200000002000000000000000000a00000000028001000000010800000000010000001008000000804000000000020000040000880000000000000000000000000000000000000000000000800000000800020004000000840000000002000000000000000000001400 
select DISTINCTCOUNTRAWHLLPLUSMV(DivAirports, 1) AS value
from airlineStats 
where arraylength(DivAirports) > 1
value
0000000100000004000000e4