Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1102

Use same set of keys to distribute rows when planner generates exchange for a join operator.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Today, planner might use a different key sets when generate hash-to-random exchange operator for a join's left and right side.

      For instance, if we have join condition :
      L1 = R1 and L2 = R2,

      Planner may generate a plan where the join's left side is hash distributed using L1, while the right side is hash distributed using (R1, R2). Such plan is not valid, since it would produce wrong query result.

      To do that, we need make sure the planner will use the same set of keys when ask for hash distribution for a join's left and right side.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jni Jinfeng Ni
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: