[jira] [Updated] (CALCITE-857) Add SortJoinTransposeRule

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated CALCITE-857:
--------------------------------------------
    Description: 
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.


  was:
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.


> 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.



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