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

Improve design of join-like relational expressions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.19.0
    • 1.20.0
    • core

    Description

      The existing join-like (Join, SemiJoin, Correlate, etc.) logical and physical relational expressions have a few design issues which make some parts of the codebase complicated and difficult to understand.

      The goal of this ticket is to improve the design of the respective expressions based on the discussion in the dev list (see thread Join, SemiJoin, Correlate).

      Attachments

        Issue Links

          Blocked

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3036 Remove correlate variables from Join

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-2973 Allow theta joins that have equi conditions to be executed using a hash join algorithm

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4819 SemiJoin operator is not skipped in materialized view-based rewriting algorithm

          • Major - Major loss of function.
          • Closed
          contains

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3037 Rename EnumerableThetaJoin to EnumerableNestedLoopJoin

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

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3089 Deprecate EquiJoin

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. CALCITE-4623 SemiJoinRule should not match SEMI join

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. CALCITE-3133 Remove completely SemiJoinType

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3102 Deprecation warnings following [CALCITE-2969]

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2857 Complicated plan generated for subuqery with both equi and non-equi condition

          • Major - Major loss of function.
          • Open
          supercedes

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-2968 New AntiJoin relational expression

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

          Web Link GitHub Pull Request #1157

          Activity

            People

              danny0405 Danny Chen
              zabetak Stamatis Zampetakis
              Votes:
              0 Vote for this issue
              Watchers:
              10 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 - 31h
                  31h