You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chan (JIRA)" <ji...@apache.org> on 2019/08/17 01:59:00 UTC
[jira] [Commented] (CALCITE-3255) CannotPlanException: There are
not enough rules to produce a node with desired properties
[ https://issues.apache.org/jira/browse/CALCITE-3255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16909539#comment-16909539 ]
Danny Chan commented on CALCITE-3255:
-------------------------------------
Thanks, [~Water Cut Off], this is an expected behavior, The relational node cost would be infinite if the convention is NONE, you should first set up your desired conventions in the target target traits[1], and define you node transform converters[2].
You should also supply the metadata in you convention nodes, so that our metadata system can compute the cumulative cost correctly.
[1] [https://github.com/apache/calcite/blob/a68bfc96bacc95b4b8ab5d185bb5cc1991113769/core/src/main/java/org/apache/calcite/tools/Program.java#L38]
[2] https://github.com/apache/calcite/blob/a68bfc96bacc95b4b8ab5d185bb5cc1991113769/core/src/main/java/org/apache/calcite/rel/convert/ConverterRule.java#L35
> CannotPlanException: There are not enough rules to produce a node with desired properties
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-3255
> URL: https://issues.apache.org/jira/browse/CALCITE-3255
> Project: Calcite
> Issue Type: Bug
> Environment: !image-2019-08-16-18-09-57-964.png!
> Reporter: Water Cut Off
> Priority: Major
> Attachments: image-2019-08-16-18-09-57-964.png
>
>
> 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:
> {color:#FF0000}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.{color}
> {color:#FF0000} Root: rel#40:Subset#4.NONE.[]{color}
> {color:#FF0000} Original rel:{color}
>
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)