You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "gianm (via GitHub)" <gi...@apache.org> on 2023/11/01 06:13:00 UTC

[PR] Use filters for pruning properly for hash-joins. (druid)

gianm opened a new pull request, #15299:
URL: https://github.com/apache/druid/pull/15299

   Native used them too aggressively: it might use filters for the RHS to prune the LHS. MSQ used them not at all. Now, both use them properly, pruning based on base (LHS) columns only.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Use filters for pruning properly for hash-joins. (druid)

Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm commented on PR #15299:
URL: https://github.com/apache/druid/pull/15299#issuecomment-1792536682

   > LGTM. Should we put something in the docs so users can leverage this and range partitioning for faster querying from deep storage?
   
   Probably a good idea to emphasize that range partitioning is potentially game changing for querying from deep storage. It can have big impact on how much data needs to be fetched per query.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Use filters for pruning properly for hash-joins. (druid)

Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm commented on PR #15299:
URL: https://github.com/apache/druid/pull/15299#issuecomment-1792537003

   thanks for the review!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Use filters for pruning properly for hash-joins. (druid)

Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm merged PR #15299:
URL: https://github.com/apache/druid/pull/15299


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org