[CALCITE-3255] CannotPlanException: There are not enough rules to produce a node with desired properties

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 1.21.0

Environment

• Assignee: Danny Chen
• Reporter: Water Cut Off
• Created: 16/Aug/19 10:10
• Updated: 10/Sep/19 21:37
• Resolved: 17/Aug/19 01:59

Description

I want to use calcite volcano planner to estimate sql cost,but it doesn't work when i try to test a case,The exception is blow:

org.apache.calcite.plan.RelOptPlanner$CannotPlanException: There are not enough rules to produce a node with desired properties: convention=NONE, sort=[]. All the inputs have relevant nodes, however the cost is still infinite.
Root: rel#40:Subset#4.NONE.[]
Original rel: