You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2015/08/28 17:47:45 UTC

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

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)