4paradigm / 4paradigm/OpenMLDB

`LongWindowOptimized` pass should select the best pre-aggr table if there are multiple

Open
#2,461 0 comments 0 reactions 1 assignee Claimed by @zhanghaohit View on GitHub
bug execute-engine
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Bug Description**
Currently the `LongWindowOptimized` pass just select the first one pre-aggr table and use it.

**Expected Behavior**
Two possible solutions:
- only create one pre-aggr table if all the meta is same expect the bucket size
- select the best pre-aggr if there are multiple pre-aggr tables exists for the same meta

Contributor guide

Open the contributing guide

Research direction

Look for the LongWindowOptimized pass in the codebase, likely in a query optimizer or planner module. Identify where pre-aggregation tables are selected. Examine the metadata comparison logic to understand how to choose the 'best' table based on bucket size or other criteria. Running existing tests related to window optimization will help verify the fix.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
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.