stored procedure

Hi, As part of my research project, we would like to use the stored procedure. do you have any pointers for the implementation of stored procedures or any alternatives in Calcite? Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com

Re: Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

/2020/conf/edbt/paper_330.pdf https://openproceedings.org/2020/conf/edbt/videos/demo-session2a/4_LekshmiAndreasKlausStefanJuergen.mp4 More papers are on the way... Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Sun, May 10, 2020 at 4:54 AM Julian Hyde wrote: > Calcite is be

Re: Filterable table

table is enough to use Project push down as well? Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Fri, Aug 9, 2019 at 11:15 AM Danny Chan wrote: > Hi, Lekshmi ~ > > > The FilterableTable can be scanned with a list of filter expression, that > means the filter c

Filterable table

Hi, Can anyone explain to me what is the advantage of Filterable Table? How can we efficiently make use of that in a Federated system? Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com

Re: Calcite's CBO

Hi Stamatis, Thanks a lot for the quick response and support. I think, now I can give an overview of the cost model used in calcite to my other group members. , Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Tue, Feb 12, 2019 at 1:58 PM Stamatis Zampetakis wrote: >

Re: Calcite's CBO

(az) then go with the plan having (x,y,z) ... comparing the record elements one by one.. Is this correct? to compare the cost records in Calcite? Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Sat, Feb 9, 2019 at 12:51 AM Julian Hyde wrote: > In retrospect, I think it was a m

Re: Calcite's CBO

; -- > Michael Mior > mm...@apache.org > > Le jeu. 7 févr. 2019 à 04:55, Lekshmi a écrit : > > > > Dear Michael Mior, > >Thank you so much for the reply. But still, I'm confused with > following > > > > When I connected PostgreSQL with Calcite and execute TPCH

Re: Calcite's CBO

? because i/o is also not an integer above. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Thu, Feb 7, 2019 at 1:37 AM Michael Mior wrote: > You're correct that it's not a single value. That said, in practice, > not much is actually done with. CPU or I/O cost. You'

Re: Calcite's CBO

connecting calcite across multiple systems, then 'i/o' should be greater than '0.0', right? Because it needs to read the results from the push-down operations? Can you please explain these in a bit more detail? I appreciate your support and suggestions. Thanks and Regards Lekshmi B.G Email

Calcite's CBO

Hi, I would like to know about the Calcite CBO in detail, including how it deals with global optimization when multiple processing systems are associated with it. Any documentation, pointers are much appreciated. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com

Re: Question Regarding The Benchmark of Calcite Compared To Conventional Database System(Related to CALCITE-2169)

to contribute towards the benchmark analysis for Calcite. The JMH benchmark test for TPC-H and the results of its comparison with postgres is also attached to this email. Please find them and I appreciate your feedback in this regard. Thanking you Lekshmi B.G Email: lekshmib...@gmail.com On Mon

Re: Question Regarding The Benchmark of Calcite Compared To Conventional Database System(Related to CALCITE-2169)

Hi Julian, Thanks for a lot for the prompt response and support. I will try running the test with JMH and will let you know the feedback. I wish you all have a prosperous new year. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Mon, Dec 31, 2018 at 10:38 AM Julian Feinauer

Question Regarding The Benchmark of Calcite Compared To Conventional Database System(Related to CALCITE-2169)

bility. But, if I fail to give a good case study in favour of Calcite, I am afraid that I could loose an opportunity to work with calcite. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com

Re: execution time and planning time from Calcite

simplicity and extensibility. But, if I fail to give a good case study in favour of Calcite, I am afraid that I could loose an opportunity to work with you guys. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com On Fri, Dec 28, 2018 at 8:28 AM Stamatis Zampetakis wrote: > Hi Leks

Re: execution time and planning time from Calcite

Thanks Stamatis I will look into that and get back to you On Sat, 1 Dec 2018, 10:28 am Stamatis Zampetakis Hi Lekshmi, > > I don't think that you can obtain this information easily. The current > implementation of explain does not seem to provide this information. > If you

execution time and planning time from Calcite

t the execution time and planning time of a query from calcite..It would be great, if anyone help me.. Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com