Re: [ANNOUNCE] Sergey Nuyanzin joins Calcite PMC

2024-03-05 Thread Hanumath Maduri
Congratulations, Sergey! On Tue, Mar 5, 2024 at 1:24 PM Francis Chuang wrote: > Congratulations, Sergey! > > On 6/03/2024 5:59 am, Ruben Q L wrote: > > Congratulations Sergey! > > > > > > On Tue, Mar 5, 2024 at 6:48 PM Tanner Clary .invalid> > > wrote: > > > >> Congrats Sergey! > >> > >>

Re: [DISCUSS] Ensuring that Calcite is consistent with other SQL systems

2024-02-26 Thread Hanumath Maduri
It seems to have support for PostGIS, but I didn't test it though. https://github.com/testcontainers/testcontainers-java/blob/main/modules/postgresql/src/main/java/org/testcontainers/containers/PostgisContainerProvider.java https://testcontainers.com/modules/postgis/ Thanks Hanu On Mon, Feb 26,

Re: [DISCUSS] Ensuring that Calcite is consistent with other SQL systems

2024-02-25 Thread Hanumath Maduri
I think leveraging testContainers ( https://java.testcontainers.org/quickstart/junit_4_quickstart/) could automate the process effectively. TestContainers provides modules for different databases such as MySQL, Oracle ( https://github.com/testcontainers/testcontainers-java/tree/main/modules),

Re: Review request.

2024-02-20 Thread Hanumath Maduri
4 at 5:53 PM Hanumath Maduri > wrote: > > > > Hello Developers, > > > > I've had a pull request (https://github.com/apache/calcite/pull/3640) > open > > for review over the past few weeks. > > I want to extend my gratitude to Mihai and Ruben for their thorough

Review request.

2024-02-19 Thread Hanumath Maduri
Hello Developers, I've had a pull request (https://github.com/apache/calcite/pull/3640) open for review over the past few weeks. I want to extend my gratitude to Mihai and Ruben for their thorough review and valuable feedback. I've addressed all the comments provided. This fix is crucial for our

Re: Rewrite rule to convert self-joins into scans

2023-05-09 Thread Hanumath Maduri
lt on top of that. The > identification part is somewhat pluggable and it could be different > depending on the use-case. > > Best, > Stamatis > > [1] > https://github.com/zabetak/docs/blob/main/2023-03-09-Hive-cbo-cte-optimization/index.md > > On Sun, Apr 30, 202

Re: Rewrite rule to convert self-joins into scans

2023-04-30 Thread Hanumath Maduri
seems reasonable to all of you. @Stamatis and @Julian, Please let me know if you got a chance to take a look at the document and are in-line with the approach. Any suggestions/clarifications on this approach would be very helpful. Thanks, On Mon, Apr 24, 2023 at 7:25 PM Hanumath Maduri wrote: >

Re: Rewrite rule to convert self-joins into scans

2023-04-24 Thread Hanumath Maduri
Thanks Julian and Stamatis for sharing your thoughts on this optimization. I have jotted down a general approach which could optimize the common subexpression with join elimination use cases in the following document. Please go through this