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

Posted to dev@calcite.apache.org by "Stamatis Zampetakis (JIRA)" <ji...@apache.org> on 2018/09/12 15:09:00 UTC

[jira] [Created] (CALCITE-2554) Enrich EnumerableJoin opetaror with order preserving information

Stamatis Zampetakis created CALCITE-2554:
--------------------------------------------

             Summary: Enrich EnumerableJoin opetaror with order preserving information
                 Key: CALCITE-2554
                 URL: https://issues.apache.org/jira/browse/CALCITE-2554
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.17.0
            Reporter: Stamatis Zampetakis
            Assignee: Julian Hyde
             Fix For: 1.18.0


The EnumerableJoin operator is backed up by a join algorithm (org.apache.calcite.linq4j.EnumerableDefaults#join_) which preserves the order of the left (outer) input. However, this information is not reflected in the RelTraitSet and thus cannot be exploited by the optimizer. Without this information, sort operators following the join cannot be removed (using SortRemoveRule) leading to suboptimal plans.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)