Skip to content

Support sort merge join with a join condition #398

Closed

Description

@viirya

What is the problem the feature request solves?

Currently SMJ with join condition is not supported by Comet and falls back to Spark. The feature was added into DataFusion but we've not incorporated it yet. We should do it to add the support.

Describe the potential solution

No response

Additional context

No response

Activity

  1. self-assigned this
    on May 7, 2024
  2. comphead commented on May 31, 2024

    @comphead
    Contributor

    @viirya can I take it as I spent some time with SMJ?

  3. added this to the 0.2.0 milestone on Jun 14, 2024
  4. andygrove commented on Sep 20, 2024

    @andygrove
    Member

    Re-opening this since we discovered that there are some correctness and performance issues and currently have this feature disabled by default

  5. modified the milestones: 0.2.0, 0.4.0 on Nov 5, 2024
  6. andygrove commented on Nov 5, 2024

    @andygrove
    Member

    There is an existing test SortMergeJoin with join filter that we need to enable as part of closing this issue. It was ignored in #1057

  7. comphead commented on Nov 5, 2024

    @comphead
    Contributor

    Thanks @andygrove I'll take if from now

  8. assigned and unassigned on Nov 5, 2024
  9. modified the milestones: 0.4.0, 0.5.0 on Nov 11, 2024
  10. comphead commented on Nov 18, 2024

    @comphead
    Contributor

    Waiting for DataFusion 44.0.0

  11. andygrove commented on Jan 10, 2025

    @andygrove
    Member

    Re-opening this issue because we only enable this feature in tests currently due to poor performance in benchmarks

  12. modified the milestones: 0.5.0, 0.6.0 on Jan 13, 2025
  13. modified the milestones: 0.6.0, 0.7.0, 0.8.0 on Feb 3, 2025
  14. removed this from the 0.8.0 milestone on Apr 7, 2025
  15. comphead commented on May 8, 2026

    @comphead
    Contributor

    @mbutrovich do you think this can be closed?

  16. mbutrovich commented on May 8, 2026

    @mbutrovich
    Contributor

    @mbutrovich do you think this can be closed?

    When we pick up DF 54. The config gets removed in the df54 branch already.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions