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/[email protected] On Sun, Aug 7, 2022 at 5:16 AM Jiajun Xie <[email protected]> wrote: > Hi, Pranav, > You can send an email to [email protected] to subscribe. > > Actually, This way is listed in https://calcite.apache.org/community/ > > > > On Sat, 6 Aug 2022 at 23:02, Pranav Deshpande < > [email protected]> > wrote: > > > 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 list on this as well). > > > > Failing to get a reply for that, I had to send emails to the mailing list > > again (I tried subscribing but the system is demanding some kind of SSO > > login). > > > > Could you please tell me how to subscribe? I will then reply to the > > particular queries I had on each post. > > > > Thanks & Regards, > > Pranav > > > > > > > > > > > > On Fri, Aug 5, 2022, 2:06 PM Julian Hyde <[email protected]> wrote: > > > > > 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 Deshpande < > > > [email protected]> wrote: > > > > > > > > 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.) [this is helpful for data federation I > > > think]. > > > > > > > > On the mailing list, many folks are suggesting that I use Drill. > > However, > > > > the purpose of my exercise is to gain knowledge about DBMS and Query > > > > processing etc. > > > > > > > > I tried debugging open source engines that use Calcite (Drill, Druid, > > > Trino > > > > etc.) but was completely lost. > > > > > > > > Any examples/pointers/guidance around the same would be appreciated. > > > > Example, pushing down a join with a filter to a DBMS(consider jdbc > > > > msql etc.) > > > > > > > > ------------------------------------- > > > > 2. > > > > > > > > The 2nd question I have is regarding conventions and different DBMS. > > The > > > > cluster has a method to replace the trait convention(Bindable,JDBC > > etc.), > > > > and then we optimize and get the physical plan. > > > > > > > > But imagine I have both the MYSQL JDBC convnction and a cassandra > > > > convention and some user is trying to query both tables. > > > > > > > > Something like "SELECT users.username, specialdata.country from > > > > cassandraDB.user join mysqlDB.specialdata ON users.id > > > =specialdata.userid" > > > > > > > > Now, how will calcite do the optimization here? The planner is not > > > > accepting 2 different conventions. > > > > > > > > Thanks & Regards, > > > > Pranav > > > > > > > > >
