Skip to content

Support Self Join Eliminate #14758

New issue

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

#

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

Already on GitHub? # to your account

Jump to bottom
Open
Tracked by #15885
comphead opened this issue Feb 19, 2025 · 1 comment
Open
Tracked by #15885

Support Self Join Eliminate #14758

comphead opened this issue Feb 19, 2025 · 1 comment
Assignees
@atahanyorganci
Labels
enhancement New feature or request

Comments

@comphead
Copy link
Contributor

Is your feature request related to a problem or challenge?

PostgreSQL just landed elimination for the self joins for some queries
https://www.phoronix.com/news/PostgreSQL-Self-Join-Eliminate

Likely DataFusion can also benefit from it for queries like in TPCH Q21.

Describe the solution you'd like

It could be an optimizer rule to rewrite the plan to avoid self joins for some conditions

Describe alternatives you've considered

No response

Additional context

No response
@comphead comphead added the enhancement New feature or request label Feb 19, 2025
@alamb alamb mentioned this issue Apr 28, 2025
Open
22 tasks
@atahanyorganci
Copy link

I would like to work on the issue.

# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees

@atahanyorganci atahanyorganci

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@comphead @atahanyorganci