drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajay Babu Maguluri" <ajay.b...@6dtech.co.in>
Subject Apache Drill Predicate Pushdown Case
Date Wed, 31 Jul 2019 16:48:38 GMT
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.


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message