[
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
