Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3833

Support SemiJoin in EnumerableMergeJoin

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.21.0
    • 1.23.0
    • core

    Description

      Currently, EnumerableMergeJoin only supports INNER joins. The goal of this ticket is to improve this join operator in order to support SEMI joins too.

      Note: RelMdCollation#mergeJoin will need to be modified too: in case of SEMI join, it must return just the leftCollations.

      Attachments

        Issue Links

          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3285 EnumerableMergeJoin should support non-equi join conditions

          • Major - Major loss of function.
          • Closed
          is related to

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-3834 Support AntiJoin in EnumerableMergeJoin

          • Major - Major loss of function.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-4113 Support LEFT join in EnumerableMergeJoin

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #1883

          Activity

            People

              rubenql Ruben Q L
              rubenql Ruben Q L
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h
                  2h