Hi All, I'm new to Calcite, so this may be a silly question. How can I control the behavior of the VolcanoPlanner when two rules match the same relation node and transform it? I am seeing an issue where I have two Rules (RuleA and RuleB) which match a LogicalProject relation node. When RuleA matches it transforms the relational node to a ProjectA node, and when RuleB matches it transforms the relational node to a ProjectB node. However, the output of the planner always has ProjectA nodes and never has ProjectB nodes. How can I tell the planner than I prefer ProjectB nodes over ProjectA nodes?
I am using the Apache Drill version of Calcite which is based on Calcite 1.4 Thanks, Tim
