[CALCITE-850] Remove push down expressions from FilterJoinRule and create a new rule for it

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 20/Aug/15 09:58
• Updated: 27/Feb/24 22:24
• Resolved: 21/Aug/15 11:12

Description

CALCITE-457 added pushing expressions in join conditions into projects below the join in the FilterJoinRule, so the expression would be computed beforehand and not in the join predicate.

While this can be an interesting feature for some projects using Calcite, it is a different functionality and it should be a standalone independent rule. For instance, in Hive we do not want to enable it at the moment, as it causes some performance regressions in many test cases.

Issue Links

• is related to: CALCITE-457 Push condition of non-ansi join into join operator