apache / apache/pinot

Add NULL support in count function

Open
#7,543 5 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.