Re: Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2019-01-15 Thread Stamatis Zampetakis
gt; > > > > > > > > > ---------- Forwarded message ------ > > > From: Kumar Vishal > > > To: dev@calcite.apache.org > > > Cc: > > > Bcc: > > > Date: Mon, 7 Jan 2019 15:44:57 +0530 > > > Subject: Re: [Query] Can

Re: Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2019-01-15 Thread Kumar Vishal
rom: Kumar Vishal > > To: dev@calcite.apache.org > > Cc: > > Bcc: > > Date: Mon, 7 Jan 2019 15:44:57 +0530 > > Subject: Re: [Query] Can we use calcite for rewriting the query based on > > Materialized View > > Hi Stamatis, > > > > I have

Re:Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2019-01-15 Thread Anupam Aggarwal
t; From: Kumar Vishal > To: dev@calcite.apache.org > Cc: > Bcc: > Date: Mon, 7 Jan 2019 15:44:57 +0530 > Subject: Re: [Query] Can we use calcite for rewriting the query based on > Materialized View > Hi Stamatis, > > I have converted my testcase to UT, please find it in th

Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2019-01-07 Thread Kumar Vishal
Hi Stamatis, I have converted my testcase to UT, please find it in the attachment. -Regards Kumar Vishal On Sat, Dec 22, 2018 at 1:32 PM Stamatis Zampetakis wrote: > Hi Kumar, > > I think it would be helpful if you could shape your code into a unit test > and share it with us. It will be easie

Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2018-12-22 Thread Stamatis Zampetakis
Hi Kumar, I think it would be helpful if you could shape your code into a unit test and share it with us. It will be easier for people to understand what is happening and possibly give you some hints. Best, Stamatis Στις Παρ, 21 Δεκ 2018 στις 6:17 μ.μ., ο/η Kumar Vishal < kumarvishal1...@gmail.c

Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2018-12-21 Thread Kumar Vishal
Hi Stamatis, I have referred MaterializationTest as you suggested, I have created a Schema similar to one present in the testcase and added Materialized View. I have created HepPlanner with all the rules present in AbstractMaterializedViewRule but when I am applying rules it's able to select the M

Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2018-12-10 Thread Kumar Vishal
Hi Stamatis, Thanks for the info, I will check this and get back to you. -Regards Kumar Vishal On Sun, Dec 9, 2018 at 6:46 PM Stamatis Zampetakis wrote: > Hi Kumar, > > Yes, it is possible. > > As long as you have your schema defined you can create a Planner (Volcano, > or Heuristic) with the

Re: [Query] Can we use calcite for rewriting the query based on Materialized View

2018-12-09 Thread Stamatis Zampetakis
Hi Kumar, Yes, it is possible. As long as you have your schema defined you can create a Planner (Volcano, or Heuristic) with the appropriate rules for view based rewritting and obtain a plan that is using the views. Then you can pass from a plan back to sql using RelToSqlConverter. You might fin

[Query] Can we use calcite for rewriting the query based on Materialized View

2018-12-07 Thread Kumar Vishal
Hi Dev, I am a new bee and analysing Calcite Materialized View. In my scenario I have multiple execution engines which have their own parser and optimizer(Some do not have integration with calcite). I want to register all the tables and Materialized Views to Calcite and handle commonly for all exe