You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Manoj Kumar <ma...@bigzetta.com> on 2020/10/07 09:30:11 UTC

[BUG][HIVE 3.1.0][LLAP] Wrong result on multiple queries

Hi  all,

Getting the wrong result on multiple queries.

On further debug it seems queries follow a common pattern on reduce side
chain of mapjoin.

[Observation]
If we have a chain of mapjoin on the reduce side, each mapjoin gets side
tables as buckted.
Ideally in a chain of map joins we should get side table as broadcast
except for the first side table.

Attaching pla of TPCH Q5 for reference.

[image: Screenshot from 2020-10-07 14-55-37.png]




-- 
Regards,
Manoj  Kumar