apache / apache/pinot

Proper support for filter in SELECT clause, IS TRUE/FALSE, and use boolean expression as predicate

Open
#9,217 4 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

1. **NOT** IN.
`select * from job where id not in ('')` -- This query already works
`select id not in ('') from job` -- This query does not work

2. **NOT** BETWEEN a AND b
3. IS **NOT** TRUE, IS **NOT** FALSE
Note: This requires supporting IS TRUE, and IS FALSE

4. **NOT** boolean_function. Examples:
NOT STARTSWITH(...)

Contributor guide

Open the contributing guide

Research direction

No files or tests are named. Start by tracing Pinot's SQL parsing and expression handling for SELECT-list predicates, then verify support for NOT IN, NOT BETWEEN, IS TRUE/FALSE, and NOT boolean functions with focused query tests; done means each listed form parses and evaluates correctly.

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.