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. >