Hello Drill Users,
I have an requirement to query the federated data resides in different vendors DB's in different servers, let's take an example SQL: SELECT t1.NAME,t2.AMOUNT FROM server1.mysql.USERS AS t1 INNER JOIN server2.oracle.PURCHASES AS t2 ON t1.ID =t2.USER_ID WHERE t1.NAME ='ABC' AND t2.TYPE ='Sales'; When I am executing this query t2.TYPE ='Sales' filter was not push down to the table level so here, 1. How Drill will overcome entire table scan can cause the performance impact. 2. How to push t2.TYPE ='Sales' filter to table level. Thanks and Regards Ajay Babu Maguluri.