Apache Pinot Docs
Search…
DISTINCTCOUNTHLLMV
This section contains reference documentation for the DISTINCTCOUNTBITMAPMV function.
Returns the count of distinct row values in a group. This function is accurate for INT or dictionary encoded column, but approximate for other cases where hash codes are used in distinct counting and there may be hash collision.
Signature
DISTINCTCOUNTBITMAPMV(colName)
Usage Examples
1
select DISTINCTCOUNTBITMAPMV(DivLongestGTimes) AS value
2
from airlineStats
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
34
1
select DISTINCTCOUNTBITMAPMV(DivTailNums) AS value
2
from airlineStats
3
where arraylength(DivTailNums) > 1
Copied!
value
2
Last modified 5mo ago
Copy link