Join tables from same data source


I’ve been trying to join multiple tables from the same SQL data source (MySQL). However Dremio does a complete table scan and then performs the join locally rather than pushing down the joins.

Is that expected or is there a way around this?


Hi @rishabh296

Can you please share the Dremio query profile?