crate / crate/crate

Support DISTINCT in the SUM function

Open
#19,665 2 comments 0 reactions 0 assignees View on GitHub
feature: sql: aggregations
Dominant language
Java
Stars
4.4k
Forks
616
Avg merge
14h 49m
Merged PRs (30d)
206

Description

Currently, `SUM()` doesn't support the `DISTINCT`, so something like `SUM(DISTINCT "columnName")` isn't possible.

Contributor guide

Open the contributing guide

Research direction

The issue names no files, tests, or entry points. Begin by locating the SUM aggregate implementation and existing aggregate tests, then verify that SUM(DISTINCT "columnName") is accepted and produces the expected result without changing ordinary SUM behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.