Join tables from same data source

Hello,

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?

Thanks

Hi @rishabh296

Can you please share the Dremio query profile?