Konstantin Orlov created IGNITE-15203: -----------------------------------------
Summary: Calcite. Extract Filter and Project related rules to separate HEP phase Key: IGNITE-15203 URL: https://issues.apache.org/jira/browse/IGNITE-15203 Project: Ignite Issue Type: Improvement Components: sql Reporter: Konstantin Orlov Assignee: Konstantin Orlov Currently the query like follow requires too mush time to optimise (> 5 minutes on my laptop): {code:java} select * from t1 inner join t2 on t1.id = t2.id where t1.val1 > 0 or t1.val2 > 10 {code} The reason is that every step of push down of the filter creates one more valid plan, that in conjunction with OrToUnion rule and all those Join's traits propagation significally boosts the search space. We could take an advantage of heuristic planner here to push down filters as close to the leaf as possible, whereas pruning all alternative plans. -- This message was sent by Atlassian Jira (v8.3.4#803005)