Jesus Camacho Rodriguez created CALCITE-857:
-----------------------------------------------

             Summary: Add SortJoinTransposeRule
                 Key: CALCITE-857
                 URL: https://issues.apache.org/jira/browse/CALCITE-857
             Project: Calcite
          Issue Type: New Feature
          Components: core
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Given a left or right outer join and a sort operator on top of it, we would 
like to add a planner rule that pushes the sort operation to the left or right 
input of the join, respectively.

We could provide two versions of the rule:
- Simple: If the Sort operator consists of a limit operation, it could be 
pushed to the input and the original one could be removed.
- Extended: in addition the simple case, if the Sort operator consists of a 
limit and a sort operation, we could push the Sort operator to the input while 
still keeping the original Sort operator in place.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to