Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5956

Optimize LeftSemiJoin For SortMergeJoin

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.15.0
    • 5.1.0, 4.16.0
    • None
    • None

    Description

      When LHS left semi join RHS through SortMergeJoinPlan, if RHS is end and returns null, then the left semi join could end early, but for SortMergeJoinPlan.SemiAntiJoinIterator , it would continue until LHS is exhausted even if RHS returns null, which is unnecessary.

      Attachments

        1. PHOENIX-5956_v1-4.x.patch
          14 kB
          chenglei

        Activity

          People

            comnetwork chenglei
            comnetwork chenglei
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: