[
https://issues.apache.org/jira/browse/HIVE-1561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12900384#action_12900384
]
He Yongqiang commented on HIVE-1561:
------------------------------------
Amareshwari, did you use BucketizedHiveInputFormat for your query? SMBJoin can
only work with BucketizedHiveInputFormat.
> 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.
