Apache Pinot Docs
latest
Search
K

DISTINCTSUM

This section contains reference documentation for the DISTINCTSUM function.
Returns the sum of distinct row values in a group

Signature

DISTINCTSUM(colName) or sum(distinct col)

Usage Examples

These examples are based on the Batch Quick Start.
SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats
VALUE
13922
SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats
VALUE
244032