And Calcite has always done this. See a presentation I gave 12 years ago! https://www.slideshare.net/slideshow/optiq-a-sql-frontend-for-everything
> On Dec 4, 2024, at 7:52 AM, Charles Givre <cgi...@apache.org> wrote: > > Hi Aditya, > You might want to look at how Apache Drill does this. Drill uses Calcite for > query planning and within Drill, you can query multiple disparate data > sources within a single query. > Best, > — C > >> On Dec 4, 2024, at 02:04, 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. >
