[
https://issues.apache.org/jira/browse/HIVE-1561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12900161#action_12900161
]
He Yongqiang commented on HIVE-1561:
------------------------------------
This is the complete result from Hive's smb_mapjoin_8.q.out, it's correct:
{noformat}
POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join
smb_bucket4_2 b on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: defa...@smb_bucket4_2
POSTHOOK: Input: defa...@smb_bucket4_1
POSTHOOK: Output:
file:/tmp/jssarma/hive_2010-07-21_12-02-34_137_8141051139723931378/10000
POSTHOOK: Lineage: smb_bucket4_1.key SIMPLE
[(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int,
comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_1.value SIMPLE
[(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string,
comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_2.key SIMPLE
[(smb_bucket_input)smb_bucket_input.FieldSchema(name:key, type:int,
comment:from deserializer), ]
POSTHOOK: Lineage: smb_bucket4_2.value SIMPLE
[(smb_bucket_input)smb_bucket_input.FieldSchema(name:value, type:string,
comment:from deserializer), ]
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
NULL NULL 5000 val_125
{noformat}
> 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.
