Thanks Robert for sharing documents. But there is no input on predicate pushdown support for join queries.
So I am assuming that Drill still does not support any predicate pushdown with simple or complex join queries against single data store or against multiple federated data stores. Regards Chetan -----Original Message----- From: Robert Hou [mailto:r...@mapr.com] Sent: Wednesday, October 18, 2017 3:14 AM To: user@drill.apache.org Subject: Re: Predicate Pushdown in Drill There is some information in the docs: https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_partition-2Dpruning-2Dintroduction_&d=DwIFAw&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=BTR7HzXoncw48Hww5aEYwE0S2huONpyF1J6KoTlYhls&s=TRavh_UTm2G6qfRkxU7XORlZC-AGMfGQ3PpcupWdK1E&e= https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_parquet-2Dfilter-2Dpushdown_&d=DwIFAw&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=BTR7HzXoncw48Hww5aEYwE0S2huONpyF1J6KoTlYhls&s=jjIcO-pNq-S6N_LBe3wZnO3ri2h1qEGiFw5rbKdZDZw&e= I don't believe we push predicates past a join. Thanks. --Robert ________________________________ From: Chetan Kothari <HYPERLINK "mailto:chetan.koth...@oracle.com"chetan.koth...@oracle.com> Sent: Tuesday, October 17, 2017 7:28 AM To: HYPERLINK "mailto:user@drill.apache.org"user@drill.apache.org Subject: RE: Predicate Pushdown in Drill Hi All Any inputs on following query? Regards Chetan -----Original Message----- From: Chetan Kothari Sent: Monday, October 16, 2017 9:07 AM To: HYPERLINK "mailto:user@drill.apache.org"user@drill.apache.org Subject: Predicate Pushdown in Drill Does Drill support predicate pushdown when executing join queries against single datastore or against multiple federated datastores? If yes, can you share more inputs on how Drill supports Predicate Pushdown for inner join, outer join and self-join queries. Regards Chetan