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.
