Thanks for the help!! Just subscribed to the list. :) I will check out the attached sources in the thread given by Charles and Julian. Will follow-up on the thread for any clarifications...
Regards, Aditya M. On Thu, Dec 12, 2024 at 2:36 AM Mihai Budiu <mbu...@gmail.com> wrote: > You should subscribe to the mailing list if you want to get the replies. > https://lists.apache.org/thread/c1pmqp240qr7cy4knp5rpmkmomj4lkgz > > Mihai > > ------------------------------ > *From:* Aditya Mahajan <adityamahajan3...@gmail.com> > *Sent:* Wednesday, December 11, 2024 3:29 AM > *To:* dev@calcite.apache.org <dev@calcite.apache.org> > *Subject:* Re: Tackling Query Federation Use Case using Calcite > > Hello Calcite Team, > > > May I please get any kind of update on this? Does this use-case fit Apache > Calcite's functionality? > > Any kind of help would be greatly appreciated. > > Thanks, > Aditya M. > > On Wed, Dec 4, 2024, 12:34 PM Aditya Mahajan <adityamahajan3...@gmail.com> > wrote: > > > Hello Calcite Team, > > > > Hope this email finds you well. > > > > I have a use-case which we want to tackle where we want to query with > > multiple databases using one SQL query. I have data in 2 different > > relational databases with multiple tables within them. I want to query > the > > data within them using just one SQL query referencing tables from both > > databases. The query should support following operations on the data > within > > the tables in the relational databases: JOINs, GROUP BY HAVING, > > AGGREGATION functions, PROJECTIONS, WINDOW Functions, etc. > > > > Will Caclite help in solving such Query (or Data) Federation use-cases? > If > > yes, is there any kind of documentation, videos or articles that will be > > useful in solving this problem? > > > > Your help is much appreciated. > > > > Thanks & Regards, > > Aditya M. > > >
