drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chetan Kothari <chetan.koth...@oracle.com>
Subject RE: Predicate Pushdown in Drill
Date Wed, 18 Oct 2017 04:46:57 GMT
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:rhou@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.kothari@oracle.com"chetan.kothari@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

 

 

 

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