hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4689) For outerjoins, joinEmitInterval might make wrong result
Date Tue, 02 Jul 2013 00:31:21 GMT

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

Navis commented on HIVE-4689:
-----------------------------

Sorry, I was busy for these days. 

I think disabling joinEmitInterval for all outer joins seemed too much. This problem occurs
when alias-filter is needed, which is used only for outer joins with condition on 'on' clause.
Current patch is for that.
                
> For outerjoins, joinEmitInterval might make wrong result
> --------------------------------------------------------
>
>                 Key: HIVE-4689
>                 URL: https://issues.apache.org/jira/browse/HIVE-4689
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.11.0
>            Reporter: Navis
>            Assignee: Navis
>         Attachments: HIVE-4689.D11211.1.patch
>
>
> Alias filter tag is calculated for each group and used for outer joins. But if joinEmitInterval
is smaller than the group size, pre-matured alias filter tag would be used and might introduce
different(wrong) result.
> It can be observed in join_1to1.q test but I cannot imagine proper solution which does
not override intention of joinEmitInterval. Should it be disabled for outer joins?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message