hive-dev mailing list archives

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


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:
>             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:

View raw message