arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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.

hashtag
Signature

DISTINCTCOUNTBITMAP(colName)

hashtag
Usage Examples

These examples are based on the .

value
value
select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats 

7

148

Batch Quick Start
select DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats