[
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)
