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

Add SemiJoinRule, planner rule to convert project-join-aggregate into semi-join

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.9.0-incubating
    • None
    • None

    Description

      Semi-join is an important logical relational expression but many query sources (e.g. SqlToRelTranslator) do not generate them. This rule would create SemiJoinRel if it sees a join that aggregates its right input on the join key; a project on top is necessary to be sure that columns from the right side of the join are not being used.

      Also, add class JoinInfo and a method on JoinRelBase 'public JoinInfo analyzeCondition()', to make it easier to analyze whether join conditions are equi-joins.

      Attachments

        Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-330 Add a rule that converts join-on-aggregate to semi-join

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

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-328 Introduce semi-join-like flag in JoinRelBase

          • Major - Major loss of function.
          • Open

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: