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)