[ 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.