apache / apache/pinot

Investigate window-function alias loss in planner snapshot expectations

Open
#18,225 1 comment 0 reactions 0 assignees View on GitHub
java multi-stage priority: low query testing
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

### Motivation
`pinot-query-planner/src/test/resources/queries/WindowFunctionPlans.json` repeats the note `TODO: Look into why aliases are getting ignored in the final plan` across multiple cases.

That suggests either a genuine alias-propagation bug in the planner or stale expected outputs in the snapshot file.

### Scope
- Determine whether aliases should survive to the final explain plan for these window queries.
- Fix planner behavior or refresh the plan snapshots.
- Remove the repeated TODO notes once expectations are stable.

### Notes
Observed on `upstream/master` on April 15, 2026.

Contributor guide

Open the contributing guide

Research direction

Start with pinot-query-planner/src/test/resources/queries/WindowFunctionPlans.json and review the repeated alias TODOs for the window-query cases. Determine whether aliases should appear in the final explain plans, then inspect the planner behavior or snapshot expectations accordingly. Done means the behavior or snapshots are stable and all repeated TODO notes are removed.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.