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

Optimize (left outer) (anti) semi join with other conditions #8262

Closed
gengliqi opened this issue Oct 27, 2023 · 0 comments · Fixed by #8339
Closed

Optimize (left outer) (anti) semi join with other conditions #8262

gengliqi opened this issue Oct 27, 2023 · 0 comments · Fixed by #8339
Labels
type/enhancement Issue or PR for enhancement

Comments

@gengliqi
Copy link
Contributor

gengliqi commented Oct 27, 2023 •
edited

Enhancement

  1. in current implementation, (left outer) (anti) semi join with conditions must combine all the matched rows for the one left row and then calculate the expressions of other conditions. In fact, semi join can finish quickly under some conditions. We can optimize this case.
  2. left outer (anti) semi join does not split the block if the block is too large. It may lead to OOM.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement Issue or PR for enhancement
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Optimize (left outer) (anti) semi join with other conditions gengliqi/tiflash
1 participant
@gengliqi