[HIVE-1561] smb_mapjoin_8.q returns different results in miniMr mode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: He Yongqiang
• Reporter: Joydeep Sen Sarma
• Created: 18/Aug/10 22:05
• Updated: 17/Dec/11 00:01
• Resolved: 19/Aug/10 23:42

Description

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

Issue Links

• depends upon: HIVE-1523 ql tests no longer work in miniMR mode