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

GroupJoin #7469

Open
zz-jason opened this issue Aug 23, 2018 · 2 comments
Open

GroupJoin #7469

zz-jason opened this issue Aug 23, 2018 · 2 comments
Assignees
@zz-jason
Labels
sig/execution SIG execution sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@zz-jason
Copy link
Member

zz-jason commented Aug 23, 2018 •
edited by you06
Loading

Description

There’s a case that we aggregate the data of a join and the join key is the same with the aggregation’s group-by item. If we chose hash join and hash aggregate, we’ll build a hash table twice. If we can merge them into one operator significantly speeds up query execution.
This is discussed in http://www.vldb.org/pvldb/vol4/p843-moerkotte.pdf. Implement it and see its performance on TPC-H benchmark!

Difficulty

  • Hard

Score

  • 8400

Mentor(s)

Recommended Skills

  • Relational Algebra
  • SQL optimization
  • SQL execution
@zz-jason zz-jason added type/enhancement The issue or PR belongs to an enhancement. status/TODO sig/planner SIG: Planner sig/execution SIG execution labels Aug 23, 2018
@zz-jason zz-jason self-assigned this Aug 23, 2018
@winoros winoros changed the title support groupjoin operator PCP-9: GroupJoin Oct 28, 2019
@sre-bot
Copy link
Contributor

sre-bot commented Nov 4, 2019

@qxhy123 don't have enough score, pick up failed
Progress 0/400
You may pick up some easy issues first.

@sre-bot sre-bot added the PCP-S1 label Nov 4, 2019
@sre-bot
Copy link
Contributor

sre-bot commented Nov 9, 2019

@qxhy123 don't have enough score, pick up failed
Progress 0/400
You may pick up some easy and medium level issues first.

@you06 you06 changed the title PCP-9: GroupJoin GroupJoin Feb 29, 2020
@ichn-hu ichn-hu mentioned this issue Nov 3, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zz-jason zz-jason

Labels
sig/execution SIG execution sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@zz-jason @tisonkun @sre-bot