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

Left outer join with partitioned large table and small table returns empty result.

    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

      Left outer join with a small table and a large partitioned table which not matched any partition path returns empty result .

      If there is no partitioned path with l_orderkey = 1000 in the lineitem_large, the following query should return all records which lineitem_small table has but return empty record.

      select a.l_orderkey as key1, b.l_orderkey as key2 
      from lineitem_small as a 
      left outer join lineitem_large as b
      on a.l_partkey = b.l_partkey and b.l_orderkey = 1000
      

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user babokim opened a pull request:

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

        TAJO-894: Left outer join with partitioned large table and small table returns empty result.

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

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

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

        https://github.com/apache/tajo/pull/50.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 #50


        commit 57bcd37bf2e7c3f3e9739d56ab63ba78b2bcd310
        Author: 김형준 <babokim@babokim-macbook-pro.local>
        Date: 2014-06-30T01:06:41Z

        TAJO-894: Left outer join with partitioned large table and small table returns empty result.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user babokim opened a pull request: https://github.com/apache/tajo/pull/50 TAJO-894 : Left outer join with partitioned large table and small table returns empty result. You can merge this pull request into a Git repository by running: $ git pull https://github.com/babokim/tajo TAJO-894 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/50.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 #50 commit 57bcd37bf2e7c3f3e9739d56ab63ba78b2bcd310 Author: 김형준 <babokim@babokim-macbook-pro.local> Date: 2014-06-30T01:06:41Z TAJO-894 : Left outer join with partitioned large table and small table returns empty result.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/50#issuecomment-47517401

        +1

        The patch looks good to me.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/50#issuecomment-47517401 +1 The patch looks good to me.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

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

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/50
        Hide
        hyunsik Hyunsik Choi added a comment -

        committed.

        Show
        hyunsik Hyunsik Choi added a comment - committed.
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #270 (See https://builds.apache.org/job/Tajo-master-build/270/)
        TAJO-894: Left outer join with partitioned large table and small table returns empty result. (Hyoungjun Kim via hyunsik) (hyunsik: rev 88d043467a7da5971cc3e0f535eb158cfa1d1ac5)

        • tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinBroadcast.java
        • tajo-core/src/main/java/org/apache/tajo/master/rm/TajoWorkerResourceManager.java
        • tajo-core/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java
        • CHANGES
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #270 (See https://builds.apache.org/job/Tajo-master-build/270/ ) TAJO-894 : Left outer join with partitioned large table and small table returns empty result. (Hyoungjun Kim via hyunsik) (hyunsik: rev 88d043467a7da5971cc3e0f535eb158cfa1d1ac5) tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinBroadcast.java tajo-core/src/main/java/org/apache/tajo/master/rm/TajoWorkerResourceManager.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