4paradigm / 4paradigm/OpenMLDB
`LongWindowOptimized` pass should select the best pre-aggr table if there are multiple
- 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
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