Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tracking: reduce unnecessary computation in OverWindow #18972

Open
4 tasks
stdrc opened this issue Oct 17, 2024 · 0 comments
Open
4 tasks

Tracking: reduce unnecessary computation in OverWindow #18972

stdrc opened this issue Oct 17, 2024 · 0 comments
Assignees
Milestone

Comments

@stdrc
Copy link
Contributor

stdrc commented Oct 17, 2024

  • For any rank-series, stop the iteration early when the output (rank number) is not changed any more. perf(over window): skip remaining affected rows when rank is not changed #18950
  • If changes in input row are not related to partition key, order key and window function arguments, the changes can be emitted to downstream directly.
  • For any rank-series and aggregate functions that supports incremental computation, jump to the first current key directly instead of sliding one by one.
  • For dense_rank, if a newly inserted row has same value with existing ones, then no other rows need to be updated.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant