apache / apache/hudi

Point lookup index should support is null/is not null

Open
#17,067 1 comment 0 reactions 0 assignees View on GitHub
area:index from-jira priority:high type:bug
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.