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

Validate That Planner Does Not Assume HashJoin Preserves Ordering for FS, MaprDB, or Hive


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


      Explanation provided by Boaz:

      (As explained in the design document) The new "automatic spill" feature of the Hash-Join operator may cause (if spilling occurs) the rows from the left/probe side to be returned in a different order than their incoming order (due to splitting the rows into partitions).

      Currently the Drill planner assumes that left-order is preserved by the Hash-Join operator; therefore if not changes, a query relying on that order may return wrong results (when the Hash-Join spills).

      A fix is needed. Here are few options (ordered from the simpler down to the most complex):

      1. Change the order rule in the planner. Thus whenever an order is needed above (downstream) the Hash-Join, the planner would add a sort operator. That would be a big execution time waste.
      2. When the planner needs the left-order above the Hash-Join, it may assess the size of the right/build side (need statistics). If the right side is small enough, the planner would set an option for the runtime to avoid spilling, hence preserving the left-side order. In case spilling becomes necessary, the code would return an error (possibly with a message suggesting setting some special option and retrying; the special option would add a sort operator and allow the hash-join to spill).
      3. When generating the code for the fragment above the Hash-Join (where left-order should be maintained) - at code-gen time check if the hash-join below spilled, and if so, add a sort operator. (Nothing like that exists in Drill now, so it may be complicated).


          Issue Links



              • Assignee:
                timothyfarkas Timothy Farkas
                timothyfarkas Timothy Farkas
                Aman Sinha
              • Votes:
                0 Vote for this issue
                4 Start watching this issue


                • Created: