You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Shubh Sharma <sh...@unb.ca> on 2020/10/16 20:57:50 UTC
Physical Query Plan Generation
Hello,
I am new to Apache Calcite API and am looking to generate physical query plans for SQL queries using Calcite API. Could someone guide me on which classes and methods to use for achieving this? It would be great if I can be redirected to an existing code repository that does this already, as an example.
Thanks a lot in advance!
Best regards,
Shubh
Re: Physical Query Plan Generation
Posted by Chunwei Lei <ch...@gmail.com>.
Hi Shubh,
I think some test cases in Calcite would help you a lot. For example, you
can refer to TopDownOptTest to see how it works.
[1]
https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/test/TopDownOptTest.java
Best,
Chunwei
On Sun, Oct 18, 2020 at 10:00 PM Stamatis Zampetakis <za...@gmail.com>
wrote:
> Hi Shubh,
>
> You can also have a look in the following links:
>
>
> https://lists.apache.org/thread.html/re6bb7e4db4b71296dba164ca2784efdec5b925105af0aa8f02cd3f5f%40%3Cdev.calcite.apache.org%3E
>
>
> https://lists.apache.org/thread.html/4d4019b01a9dec08467204baaf0a50f8f516241357a3e881fdde022e%40%3Cdev.calcite.apache.org%3E
>
>
> https://github.com/zabetak/calcite/commit/c7646fa6d3054b9e6b9a800e08d18f3cc89922e4
>
>
> Best,
>
> Stamatis
>
>
> On Fri, Oct 16, 2020 at 11:14 PM Rui Wang <am...@apache.org> wrote:
>
> > You can refer to function to understand Calcite planner API at higher
> > level:
> >
> >
> https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/CalciteQueryPlanner.java#L155
> >
> >
> > -Rui
> >
> > On Fri, Oct 16, 2020 at 1:58 PM Shubh Sharma <sh...@unb.ca>
> wrote:
> >
> > > Hello,
> > >
> > > I am new to Apache Calcite API and am looking to generate physical
> query
> > > plans for SQL queries using Calcite API. Could someone guide me on
> which
> > > classes and methods to use for achieving this? It would be great if I
> can
> > > be redirected to an existing code repository that does this already, as
> > an
> > > example.
> > >
> > > Thanks a lot in advance!
> > >
> > > Best regards,
> > > Shubh
> > >
> >
>
Re: Physical Query Plan Generation
Posted by Stamatis Zampetakis <za...@gmail.com>.
Hi Shubh,
You can also have a look in the following links:
https://lists.apache.org/thread.html/re6bb7e4db4b71296dba164ca2784efdec5b925105af0aa8f02cd3f5f%40%3Cdev.calcite.apache.org%3E
https://lists.apache.org/thread.html/4d4019b01a9dec08467204baaf0a50f8f516241357a3e881fdde022e%40%3Cdev.calcite.apache.org%3E
https://github.com/zabetak/calcite/commit/c7646fa6d3054b9e6b9a800e08d18f3cc89922e4
Best,
Stamatis
On Fri, Oct 16, 2020 at 11:14 PM Rui Wang <am...@apache.org> wrote:
> You can refer to function to understand Calcite planner API at higher
> level:
>
> https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/CalciteQueryPlanner.java#L155
>
>
> -Rui
>
> On Fri, Oct 16, 2020 at 1:58 PM Shubh Sharma <sh...@unb.ca> wrote:
>
> > Hello,
> >
> > I am new to Apache Calcite API and am looking to generate physical query
> > plans for SQL queries using Calcite API. Could someone guide me on which
> > classes and methods to use for achieving this? It would be great if I can
> > be redirected to an existing code repository that does this already, as
> an
> > example.
> >
> > Thanks a lot in advance!
> >
> > Best regards,
> > Shubh
> >
>
Re: Physical Query Plan Generation
Posted by Rui Wang <am...@apache.org>.
You can refer to function to understand Calcite planner API at higher
level:
https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/CalciteQueryPlanner.java#L155
-Rui
On Fri, Oct 16, 2020 at 1:58 PM Shubh Sharma <sh...@unb.ca> wrote:
> Hello,
>
> I am new to Apache Calcite API and am looking to generate physical query
> plans for SQL queries using Calcite API. Could someone guide me on which
> classes and methods to use for achieving this? It would be great if I can
> be redirected to an existing code repository that does this already, as an
> example.
>
> Thanks a lot in advance!
>
> Best regards,
> Shubh
>