You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2010/11/12 03:01:13 UTC

[jira] Commented: (HIVE-1783) CommonJoinOperator optimize the case of 1:1 join

    [ https://issues.apache.org/jira/browse/HIVE-1783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12931303#action_12931303 ] 

Namit Jain commented on HIVE-1783:
----------------------------------

+1

running tests

> CommonJoinOperator optimize the case of 1:1 join
> ------------------------------------------------
>
>                 Key: HIVE-1783
>                 URL: https://issues.apache.org/jira/browse/HIVE-1783
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Siying Dong
>            Assignee: Siying Dong
>            Priority: Minor
>         Attachments: HIVE-1783.1.patch
>
>
> CommonJoinOperator.genObject() is expensive. It does a recursive and keeps lots of states because it has to:
> 1. handle null cases for outer joins
> 2. handle the case of duplicated keys from one join party
> We can do a minor optimization to detect a 1:1 join (which is quite common) before calling CommonJoinOperator.genObject() and forward columns in a simple for-loop if we are sure neither of 1 or 2 will happen.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.