Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-13 Thread Benchao Li
Pranav, sorry that I didn't see you already posted the question to the mailing list. Benchao Li 于2022年8月14日周日 11:28写道: > Pranav, > > Reposted your mail to the dev mailing list. (It's recommended to reply to > dev mailing list instead of someone's email address) > > > So my question is better

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-13 Thread Benchao Li
Pranav, Reposted your mail to the dev mailing list. (It's recommended to reply to dev mailing list instead of someone's email address) > So my question is better phrased as: "Is there a planner rule that converts a join on 2 Table scans to some kind of table?" Are any examples available on this?

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-12 Thread Pranav Deshpande
HI Benchao, Thank you very much for your excellent suggestions! I believe that I have a better understanding about my problem now. I saw the pushdowns and also the usage of multiple conventions in the same plan, and was able to implement and play around with the same. I went through talk [4] as

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-12 Thread Pranav Deshpande
Hi Stamatis, Their documentation mentions that it is only for Apache contributors. Hence, I am unable to find a way to reply to the posts I made before I subscribed to the mailing list. Regards, Pranav On Mon, Aug 8, 2022 at 4:56 AM Stamatis Zampetakis wrote: > Hi Pranav, > > One way to reply

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-12 Thread Pranav Deshpande
Hi Jiajun Xie, I was able to subscribe and am now able to reply on various threads. However, I am still not able to reply on the past threads I created before I subscribed. Is there any way to do the same? Thanks & Regards, Pranav On Sat, Aug 6, 2022 at 10:17 PM Jiajun Xie wrote: > Hi,

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-08 Thread Stamatis Zampetakis
Hi Pranav, One way to reply to existing threads is to go to the Pony Mail service [1], click on the appropriate thread, hit the reply button, and follow the instructions there. Best, Stamatis [1] https://lists.apache.org/list.html?dev@calcite.apache.org On Sun, Aug 7, 2022 at 5:16 AM Jiajun

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-06 Thread Jiajun Xie
Hi, Pranav, You can send an email to dev-subscr...@calcite.apache.org to subscribe. Actually, This way is listed in https://calcite.apache.org/community/ On Sat, 6 Aug 2022 at 23:02, Pranav Deshpande wrote: > Hi Julian, > I apologize for the same. > > It was not my intention to do so. I

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-06 Thread Pranav Deshpande
Hi Julian, I apologize for the same. It was not my intention to do so. I very much wanted to acknowledge the replies, however, I could not do so as mentioned on my 2nd post: https://lists.apache.org/thread/27v6pymkm8qfxfkrf2pojl8w1bpmjwzc (I asked for instructions on replying back to the mailing

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-06 Thread Benchao Li
Thank you Julian for the information. Julian Hyde 于2022年8月6日周六 14:20写道: > I believe that subscriber lists are only available to mailing list > administrators. > > I know that Pranav is not subscribed because, as a moderator, I receive an > email each time he posts. > > You can find out about

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-06 Thread Julian Hyde
I believe that subscriber lists are only available to mailing list administrators. I know that Pranav is not subscribed because, as a moderator, I receive an email each time he posts. You can find out about (and manage) your own subscription status by emailing dev-h...@calcite.apache.org.

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-05 Thread Benchao Li
Julian, Could you teach me how to know whether someone has subscribed to the ML or not quickly? I searched this question and found[1], but this way is not very handy. [1] https://wiki.openoffice.org/wiki/Documentation/FAQ/General/How_to_know_if_a_user_is_subscribed_to_a_mailing_list Benchao Li

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-05 Thread Benchao Li
Pranav, You can reference Calcite adaptors implementation, such as JDBC Adaptor[1], MongoDB Adaptor[2]. Their implementation allows pushing down operations (RelNode) to the adapter as much as possible, and the left RelNodes will be implemented using Enumerable Convention. We have a Converter[3]

Re: Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-05 Thread Julian Hyde
Pranav, Please subscribe to this list. You have asked several questions, received replies, not acknowledged those replies, and asked further questions. Also, since you are not subscribed, each email you post has to go through manual moderation. Julian > On Aug 5, 2022, at 9:38 AM, Pranav

Technical Queries Regarding Pushing Down Joins & Unions To TableScans, Conventions

2022-08-05 Thread Pranav Deshpande
Dear Apache Calcite Team, I have 2 questions. - 1. There are plenty of examples on how to push down projects and filters into the leaf nodes (tablescans). However, I could not find any examples to push down joins to TableScans (or joins+filters+projects etc.)