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
Attachments
Attachments
Issue Links
- relates to
-
HIVE-15134 Branch-1.2: Investigate failure of TestMiniTezCliDriver#vector_auto_smb_mapjoin_14
- Resolved