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

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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: None
    • Labels:
      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
      

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user babokim opened a pull request:

        https://github.com/apache/tajo/pull/65

        TAJO-927: Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/babokim/tajo TAJO-927

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/65.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #65


        commit 18e2564cd03872eed82c459c776a5888b886f19c
        Author: 김형준 <babokim@babokim-mbp.server.gruter.com>
        Date: 2014-07-10T12:44:26Z

        TAJO-927: Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user babokim opened a pull request: https://github.com/apache/tajo/pull/65 TAJO-927 : Broadcast Join with Large, Small, Large, Small tables makes a wrong plan. You can merge this pull request into a Git repository by running: $ git pull https://github.com/babokim/tajo TAJO-927 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/65.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #65 commit 18e2564cd03872eed82c459c776a5888b886f19c Author: 김형준 <babokim@babokim-mbp.server.gruter.com> Date: 2014-07-10T12:44:26Z TAJO-927 : Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/65#issuecomment-48696287

        +1
        The change is straightforward and includes the unit test.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/65#issuecomment-48696287 +1 The change is straightforward and includes the unit test.
        Hide
        hyunsik Hyunsik Choi added a comment -

        Thank you for nice bug fix. committed it to master branch.

        Show
        hyunsik Hyunsik Choi added a comment - Thank you for nice bug fix. committed it to master branch.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

        https://github.com/apache/tajo/pull/65

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/65
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-build #286 (See https://builds.apache.org/job/Tajo-master-build/286/)
        TAJO-927: Broadcast Join with Large, Small, Large, Small tables makes a wrong plan. (Hyoungjun Kim via hyunsik) (hyunsik: rev 42f3b4dd8fbf1a5a46a4469c7ac919fb32089225)

        • tajo-core/src/test/java/org/apache/tajo/engine/planner/global/TestBroadcastJoinPlan.java
        • tajo-core/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java
        • CHANGES
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-build #286 (See https://builds.apache.org/job/Tajo-master-build/286/ ) TAJO-927 : Broadcast Join with Large, Small, Large, Small tables makes a wrong plan. (Hyoungjun Kim via hyunsik) (hyunsik: rev 42f3b4dd8fbf1a5a46a4469c7ac919fb32089225) tajo-core/src/test/java/org/apache/tajo/engine/planner/global/TestBroadcastJoinPlan.java tajo-core/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java CHANGES

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development