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

Support left and right outer joins with AggregateJoinTransposeRule

    XMLWordPrintableJSON

Details

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

    Description

      Currently AggregateJoinTransposeRule only support INNER join. Aggregates (at least the ones without aggregate functions) could be pushed through OUTER joins with current logic.

      Attachments

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3012 Column uniqueness metadata provider may return wrong result for FULL OUTER JOIN operator

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

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2378 AggregateJoinTransposeRule should left and right outer join

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

          Web Link GitHub Pull Request #1171

          Activity

            People

              vgarg Vineet Garg
              vgarg Vineet Garg
              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 50m
                  2h 50m