Proper support for filter in SELECT clause, IS TRUE/FALSE, and use boolean expression as predicate
Open
- 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
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