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

Add support for Join with small build side table between Lateral & Unnest subquery.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      We want to support Hash Join in Lateral & Unnest subquery for special case of small table on build side of the Hash Join. In this case basically build side is a small table which is scanned once by Hash Join and then for each left side batch with EMIT outcome, same build side information is used. The example plan will look like below: 

                   LJ
                    /    \
              Scan    HashJoin
                           /      \
                  Unnest    Scan (Build)
      

       
      Here we should also think about sniffing logic in Hash Join operator which can cause deadlock for this scenario.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              shamirwasia Sorabh Hamirwasia
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: