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

Posted to issues@calcite.apache.org by "Stamatis Zampetakis (JIRA)" <ji...@apache.org> on 2018/10/10 13:21:00 UTC

[jira] [Created] (CALCITE-2617) FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down

Stamatis Zampetakis created CALCITE-2617:
--------------------------------------------

             Summary: FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down
                 Key: CALCITE-2617
                 URL: https://issues.apache.org/jira/browse/CALCITE-2617
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.17.0
            Reporter: Stamatis Zampetakis
            Assignee: Julian Hyde
             Fix For: 1.18.0


The rule always forbids conditions with correlated variables to be pushed down (as of [CALCITE-769|https://issues.apache.org/jira/browse/CALCITE-769] to avoid certain problems in the decorrelation of the query). However, in the general context of query optimization, it is beneficial to push-down filters and the fact that there is a correlated variable is not a reason to skip this optimization. 

In order to avoid regressions, and at the same time enable correlated conditions to be pushed down we should make the pushing of correlated variables configurable. 



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