[jira] Commented: (HIVE-1561) smb_mapjoin_8.q returns different results in miniMr mode

["Namit Jain (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12900138#action_12900138 ] 

Namit Jain commented on HIVE-1561:
----------------------------------

Looked at the data in detail:

The tables should be:

smb_bucket4_1 

4             v356
2000      v169
4000     v125

smb_bucket4_2

484      v169
3000    v169
5000    v125


So, the above query should result in 6 rows - both the results are wrong

> smb_mapjoin_8.q returns different results in miniMr mode
> --------------------------------------------------------
>
>                 Key: HIVE-1561
>                 URL: https://issues.apache.org/jira/browse/HIVE-1561
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Joydeep Sen Sarma
>            Assignee: He Yongqiang
>
> follow on to HIVE-1523:
> ant -Dclustermode=miniMR -Dtestcase=TestCliDriver -Dqfile=smb_mapjoin_8.q test
> POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key
> official results:
> 4 val_356 NULL  NULL
> NULL  NULL  484 val_169
> 2000  val_169 NULL  NULL
> NULL  NULL  3000  val_169
> 4000  val_125 NULL  NULL
> in minimr mode:
> 2000  val_169 NULL  NULL
> 4 val_356 NULL  NULL
> 2000  val_169 NULL  NULL
> 4000  val_125 NULL  NULL
> NULL  NULL  5000  val_125

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