Manoj Kumar created HIVE-24239: ---------------------------------- Summary: Reduce side chain of Map join produce wrong result Key: HIVE-24239 URL: https://issues.apache.org/jira/browse/HIVE-24239 Project: Hive Issue Type: Bug Components: llap Affects Versions: 3.1.0 Reporter: Manoj Kumar Attachments: 1602055956.svg
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. -- This message was sent by Atlassian Jira (v8.3.4#803005)