Re: Re: Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-27 Thread 方丰斌
Hey Benchao, Thank you for your guidance and advice. I am very happy to be able to develop based on calcite. Thank you very much! -原始邮件- 发件人:"Benchao Li" 发送时间:2022-06-26 18:20:53 (星期日) 收件人: "方丰斌" <8692182...@zju.edu.cn>, dev@calcite.apache.org 抄送: 主题: Re: Re: Re: Looking for help:

Re: Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-26 Thread Benchao Li
Hi 丰斌, Below four kinds of Table can all fit your case. - ScannableTable - FilterableTable - ProjectableFilterableTable - QueryableTable Translatable is another different case, it provides a way for you to translate your table to your customized TableScan. If you just want to add your CK table

Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-25 Thread Benchao Li
> > I tried to add DDL statements and create a custom table (which > inherits AbstractTable). However, it is obvious that some rules cannot be > converted when CBO is started. I don't fully understand this question, could you elaborate a little more on it? Did you mean that your DDL statement

Re: Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-25 Thread 方丰斌
Thanks for your advice. My mock table inherits AbstractTable, so there is no convert. I solved the problem according to your suggestion. BTW:I tried to add DDL statements and create a custom table (which inherits AbstractTable). However, it is obvious that some rules cannot be converted when

Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-25 Thread Benchao Li
hi 丰斌, The exception message has told you the reason: > Missing conversion is LogicalTableScan[convention: NONE -> ENUMERABLE] This is mostly because your `MyRelOptSchema` returns a `Table` that cannot be transformed to Enumerable Convention. You can refer the code[1] to see why your Table

Re: Looking for help: There are not enough rules to produce a node with desired properties

2022-06-24 Thread Julian Hyde
I had to moderate your message. Can you subscribe to the list so that you receive updates. Julian > On Jun 24, 2022, at 09:37, 方丰斌 <8692182...@zju.edu.cn> wrote: > > Hey all, > > > > >I'm trying to use VolcanoPlanner. I have encountered the following > problems. I hope I can ask

Looking for help: There are not enough rules to produce a node with desired properties

2022-06-24 Thread 方丰斌
Hey all, I'm trying to use VolcanoPlanner. I have encountered the following problems. I hope I can ask for some help. Thank you very much! Test code: ` VolcanoPlanner planner = new VolcanoPlanner(); planner.addRelTraitDef(ConventionTraitDef.INSTANCE);