apache / apache/pinot

Enhance MergeRangeFilterOptimizer to rewrite predicate A < 10 OR A = 10

Open
#7,625 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

Currently, MergeRangeFilterOptimizer don't support operations to optimize query with filter patterns consisting of predicate A < 10 OR A = 10 as A<=10. this issue will track removal of that limitation and provide support for the same as part for optimizing query execution

Contributor guide

Open the contributing guide

Research direction

Locate MergeRangeFilterOptimizer and read its existing handling of range predicates. Verify how the optimizer represents A < 10 OR A = 10, then add support for rewriting that pattern as A <= 10 and confirm the optimized query behavior with the relevant optimizer tests.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases, performance
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 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.