| description |
|---|
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.
DISTINCTCOUNTBITMAP(colName)
These examples are based on the Batch Quick Start.
select DISTINCTCOUNTBITMAP(league) AS value
from baseballStats | value |
|---|
| 7 |
select DISTINCTCOUNTBITMAP(teamID) AS value
from baseballStats | value |
|---|
| 148 |