[HIVE-11517] Vectorized auto_smb_mapjoin_14.q produces different results

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0.2, 1.2.2, 1.3.0, 2.0.0
• Assignee: Matt McCline
• Reporter: Matt McCline
• Created: 11/Aug/15 04:56
• Updated: 17/Mar/17 22:41
• Resolved: 24/Sep/15 22:48

Description

Converted Q file to use ORC and turned on vectorization.

The query:

select count(*) from (
  select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
) subq1

produces 10 instead of 22.

The query:

select src1.key, src1.cnt1, src2.cnt1 from
(
  select key, count(*) as cnt1 from 
  (
    select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
  ) subq1 group by key
) src1
join
(
  select key, count(*) as cnt1 from 
  (
    select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
  ) subq2 group by key
) src2

produces:

0	3	3
2	1	1
4	1	1
5	3	3
8	1	1
9	1	1

instead of:

0	9	9
2	1	1
4	1	1
5	9	9
8	1	1
9	1	1

Issue Links

• relates to: HIVE-15134 Branch-1.2: Investigate failure of TestMiniTezCliDriver#vector_auto_smb_mapjoin_14