Apache Drill Predicate Pushdown Case

[Ajay Babu Maguluri]

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.