apache / apache/pinot

support is null or is not null checking inside case condition

Open
#7,835 11 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

Currently, null checking is only supported inside filtering. I want to support the following use case:

select case
when timeStamp IS NULL then now()
else timestamp
end
from meetupRsvp

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are named. Start by locating the existing null-check handling used during filtering and the code that evaluates CASE conditions; add coverage for IS NULL and IS NOT NULL in a CASE WHEN expression, and verify the shown query produces the expected branch result.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.