Hi, Bhavya. I think all you need to do is to create the node correctly. You can refer to how the EnumerableMergeJoin is created[1].
[1] https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/adapter/enumerable/EnumerableJoinRule.java#L86 Best, Chunwei On Fri, Nov 27, 2020 at 9:23 AM Michael Mior <[email protected]> wrote: > Do you need to use CBO for the physical operators as well? If not, you > could certainly just keep the single TableScan and perform whatever > operations you want at query execution time. If you want to use CBO > with your physical operators, there is no requirement that an > optimizer rule produce the same number of RelNodes. You could write a > rule which converts a TableScan into the tree of operators you showed > and then write further rules which manipulate the physical operators. > -- > Michael Mior > [email protected] > > Le jeu. 26 nov. 2020 à 16:53, Bhavya Aggarwal <[email protected]> a > écrit : > > > > Hi All, > > > > We are trying to use Apache Calcite as and CBO for our homegrown DB and > > there one Logical operator will translate into multiple Physical > Operations > > at our database e.g. a simple TableScan will convert into the given > > structure. In the example above we have to decompress the data, then > > rechunk it. However, I am able to create 1:1 conversion. Please let me > know > > how to proceed. Any help will be much appreciated. > > > > select id from users where id = 5; > > AddToNetworkQueue 1 > > Rechunk 2 > > ReorderInput 3 > > ReorderInput 4 > > Filter 5 > > Rechunk 6 > > Decompress 7 > > ReadTable 8 > > > > Thanks and regards > > Bhavya > > -- > > *Bhavya Aggarwal* > > CTO & Partner > > Knoldus Inc. <http://www.knoldus.com/> > > +91-9910483067 > > Canada - USA - India - Singapore > > <https://in.linkedin.com/company/knoldus> <https://twitter.com/Knolspeak > > > > <https://www.facebook.com/KnoldusSoftware/> <https://blog.knoldus.com/> > > > > -- > > Your feedback matters - At Knoldus we aim to be very professional in our > > quality of work, commitment to results, and proactive communication. If > you > > feel otherwise please share your feedback > > <https://forms.gle/Ax1Te1DDpirAQuQ8A> and we would work on it. >
