It shouldn't matter how many data sources are involved. The way the relational algebra is constructed, there will be a LogicalFilter on top of the TableScan for table2 in DB2. You would just need to implement a rule to push down filters for DB2 (if it doesn't already exist).
-- Michael Mior [email protected] 2017-07-04 10:40 GMT-04:00 Bahareh Nikfarjam <[email protected]>: > Hello, > > I am trying to use calcite to query across two databases. I have a query > that joins between table1 in DB1 and table2 in DB2. there is a filter on > table2. Is there a way in calcite to push down the filter on table 2 to the > source database? > > Thanks, > Bahareh >
