Add NULL support in count function
Open
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
To support queries like `count(col)` where `col` can have NULL values, or `count(CASE WHEN condition THEN v END)`
In certain cases, there's no workaround to calculating such values.
Contributor guide
Research direction
The issue concerns Pinot query handling for count(col) and count(CASE WHEN condition THEN v END) when values are NULL. Start by tracing the count-function implementation and its existing tests; done means these expressions return the expected counts without requiring a workaround.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100