[ 
https://issues.apache.org/jira/browse/DRILL-6755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16628170#comment-16628170
 ] 

ASF GitHub Bot commented on DRILL-6755:
---------------------------------------

Ben-Zvi opened a new pull request #1480: DRILL-6755: Avoid building Hash Table 
for inner/left join when probe side is empty
URL: https://github.com/apache/drill/pull/1480
 
 
   This PR is split into two commits to help the reviewers:
   (1) Preparations and cleanups: No change to the code's logic, only new 
definitions and minor cleaning.
   (2) The actual change: Define the flag `skipHashTableBuild` and use it to 
skip initial hash-table setting, and later to kill the build side upstream and 
skip the hash table build. (This also saves the useless work in the upstream; 
e.g., more scanning).
       Also included is a test of an inner join, with a NONE probe input, and 
multiple input batches on the build side.  

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


> HashJoin should not build hash tables when probe side is empty.
> ---------------------------------------------------------------
>
>                 Key: DRILL-6755
>                 URL: https://issues.apache.org/jira/browse/DRILL-6755
>             Project: Apache Drill
>          Issue Type: Improvement
>            Reporter: Timothy Farkas
>            Assignee: Boaz Ben-Zvi
>            Priority: Major
>
> Currently when doing an Inner or a Right join we still build hashtables when 
> the probe side is empty. A performance optimization would be to not build 
> them.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to