Point lookup index should support is null/is not null
- Dominant language
- Java
- Stars
- 6.2k
- Forks
- 2.5k
- Avg merge
- 2d 8h
- Merged PRs (30d)
- 111
Description
for secondary index, need to support is null/not null predicate
select * from mytable where secCol is null;
today this does not trigger index look up
## JIRA info
- Link: https://issues.apache.org/jira/browse/HUDI-9549
- Type: Bug
- Affects version(s):
- 1.2.0
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the reported query, `select * from mytable where secCol is null`, and trace the secondary-index point-lookup path that handles predicates. Compare it with `is not null` and verify that both predicates trigger the index lookup; done means the lookup is used for these cases without changing other query behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100