[HIVE-17073] Incorrect result with vectorization and SharedWorkOptimizer

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Vectorization
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 11/Jul/17 12:57
• Updated: 27/Feb/24 22:23
• Resolved: 12/Jul/17 15:40

Description

We get incorrect result with vectorization and multi-output Select operator created by SharedWorkOptimizer. It can be reproduced in the following way.

Correct

select count(*) as h8_30_to_9
  from src
  join src1 on src.key = src1.key
  where src1.value = "val_278";
OK
2

Correct

select count(*) as h9_to_9_30
  from src
  join src1 on src.key = src1.key
  where src1.value = "val_255";
OK
2

Incorrect

select * from (
  select count(*) as h8_30_to_9
  from src
  join src1 on src.key = src1.key
  where src1.value = "val_278") s1
join (
  select count(*) as h9_to_9_30
  from src
  join src1 on src.key = src1.key
  where src1.value = "val_255") s2;
OK
2	0

Problem seems to be that some ds in the batch row need to be re-initialized after they have been forwarded to each output.

Issue Links

• is related to: HIVE-18491 Set multichildren boolean for vectorized operators at initialization