Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-927

Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.9.0
    • None
    • None

    Description

      select count(*) from large1 
      inner join small1 on large1_id = small1_id
      left outer join large2 on large1_id = large2_id 
      left outer join small2 on large1_id = small2_id
      

      Current tajo planner makes the plan as following. All large tables(large1, large2) are scanned in a single execution block. Each table should have a execution block.

      |-eb_1404871198908_0000_000005
        |-eb_1404871198908_0000_000004
          |-eb_1404871198908_0000_000003
      

      Attachments

        Activity

          People

            hjkim Hyoungjun Kim
            hjkim Hyoungjun Kim
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: