I am using latest dremio 3.2 version. I connected to two mysql databases which are in different servers. When i am executing the join query between tables in these to databases it is doing a full table scan. The ‘where’ condition which i am giving is not getting executed in db side it’s acting as filter while processing.
In my case there is large data on these tables so full table scan won’t be good. Please assist on this.
Thanks & Regards