[jira] Resolved: (HIVE-1682) Wrong results with MAPJOIN when cols from non-MAPJOINed table are selected

["Thiruvel Thirumoolan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-1682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thiruvel Thirumoolan resolved HIVE-1682.
----------------------------------------

    Resolution: Invalid

Problem does not appear anymore.

> Wrong results with MAPJOIN when cols from non-MAPJOINed table are selected
> --------------------------------------------------------------------------
>
>                 Key: HIVE-1682
>                 URL: https://issues.apache.org/jira/browse/HIVE-1682
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>         Environment: Hive trunk (rev 1003407)
> Hadoop 20.2
>            Reporter: Thiruvel Thirumoolan
>
> Results of this query is wrong:
> set hive.mapjoin.cache.numrows=100;
> select /*+ MAPJOIN(invites) */ pokes.bar from pokes join invites on (pokes.bar = invites.bar);
> Results of all the queries below match:
> /* This is the same as problematic query without specifying numrows - which defaults to 25k much greater than the number of rows in pokes table */
> select /*+ MAPJOIN(invites) */ pokes.bar from pokes join invites on (pokes.bar = invites.bar)
> set hive.mapjoin.cache.numrows=100;
> select /*+ MAPJOIN(invites) */ invites.bar from pokes join invites on (pokes.bar = invites.bar);
> select invites.bar from pokes join invites on (pokes.bar = invites.bar);
> select pokes.bar from pokes join invites on (pokes.bar = invites.bar);

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