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.

Sign up for GitHub

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

Jump to bottom

colexecwindow: add hashing window partitioner #37228

Closed
yuzefovich opened this issue May 1, 2019 · 2 comments
Closed

colexecwindow: add hashing window partitioner #37228

yuzefovich opened this issue May 1, 2019 · 2 comments
Labels
A-sql-vec SQL vectorized engine C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team

Comments

@yuzefovich
Copy link
Member

yuzefovich commented May 1, 2019 •
edited by cockroach-jira-scripts
Loading

Add a hashing window partitioner. Likely it should be using the tuple hash distributor. This component will allow us to not sort the whole input data set when PARTITION BY clause is present whereas ORDER BY clause is omitted for a window function.

Jira issue: CRDB-4444
@yuzefovich yuzefovich added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-vec SQL vectorized engine labels May 1, 2019
@yuzefovich yuzefovich self-assigned this May 1, 2019
@yuzefovich yuzefovich mentioned this issue May 1, 2019
Closed
6 tasks
@yuzefovich yuzefovich removed their assignment Mar 14, 2020
@jlinder jlinder added the T-sql-queries SQL Queries Team label Jun 16, 2021
@yuzefovich yuzefovich changed the title exec: add hashing window partitioner colexecwindow: add hashing window partitioner Sep 7, 2021
@mgartner mgartner moved this to New Backlog in SQL Queries Jul 24, 2023
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@yuzefovich
Copy link
Member Author

TODO in the code seems sufficient to track this.

@github-project-automation github-project-automation bot moved this from New Backlog to Done in SQL Queries Sep 20, 2023
@github-project-automation github-project-automation bot moved this to [VECTORIZED BACKLOG] Enhancements/Features/Investigations in BACKLOG, NO NEW ISSUES: SQL Execution Aug 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-vec SQL vectorized engine C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
BACKLOG, NO NEW ISSUES: SQL Execution
Archived in project
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jlinder @yuzefovich