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

Support left and right outer joins with AggregateJoinTransposeRule

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.20.0
    • Component/s: 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
          links to

          Web Link GitHub Pull Request #1171

            Activity

              People

              • Assignee:
                vgarg Vineet Garg
                Reporter:
                vgarg Vineet Garg
              • Votes:
                0 Vote for this issue
                Watchers:
                4 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