Apache Pinot Docs
Search…
latest
DISTINCTCOUNTBITMAP
This section contains reference documentation for the DISTINCTCOUNTBITMAP function.
Returns the count of distinct row values in a group. This function is accurate for INT column, but approximate for other cases where hash codes are used in distinct counting and there may be hash collisions. For accurate distinct counting on all column types, see DISTINCTCOUNT.

Signature

DISTINCTCOUNTBITMAP(colName)

Usage Examples

These examples are based on the Batch Quick Start.
1
select DISTINCTCOUNTBITMAP(league) AS value
2
from baseballStats
Copied!
value
7
1
select DISTINCTCOUNTBITMAP(teamID) AS value
2
from baseballStats
Copied!
value
148
Last modified 1mo ago
Copy link