Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-24239

Reduce side chain of Map join produce wrong result

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.0
    • Fix Version/s: None
    • Component/s: llap
    • Labels:
      None

      Description

      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.

        Attachments

        1. 1602055956.svg
          182 kB
          Manoj Kumar

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              manoj_red_hat Manoj Kumar
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: