[HIVE-1682] Wrong results with MAPJOIN when cols from non-MAPJOINed table are selected

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 0.7.0

Environment

Hive trunk (rev 1003407)
Hadoop 20.2

• Assignee: Unassigned
• Reporter: Thiruvel Thirumoolan
• Created: 01/Oct/10 09:48
• Updated: 13/Dec/10 18:17
• Resolved: 13/Dec/10 18:17

Description

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);