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

NPE occurs when performing window functions after join

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.0, 0.11.0
    • Component/s: None
    • Labels:
      None

      Description

      This bug is reported from Tajo Korea user group (https://groups.google.com/forum/#!topic/tajo-user-kr/oHWg-IQqVYg).

      Here is the detailed log.

      default> select rank() over (order by n_name) from nation, region where r_regionkey = n_regionkey;
      
      ...
      2015-01-27 11:08:23,655 INFO org.apache.tajo.master.GlobalEngine: Query: select rank() over (order by n_name) from nation, region where r_regionkey = n_regionkey
      2015-01-27 11:08:23,739 ERROR org.apache.tajo.master.GlobalEngine:
      Stack Trace:
      java.lang.NullPointerException
              at org.apache.tajo.plan.util.PlannerUtil.targetToSchema(PlannerUtil.java:674)
              at org.apache.tajo.plan.logical.WindowAggNode.setTargets(WindowAggNode.java:102)
              at org.apache.tajo.plan.LogicalPlanner.insertWindowAggNode(LogicalPlanner.java:691)
              at org.apache.tajo.plan.LogicalPlanner.visitProjection(LogicalPlanner.java:247)
              at org.apache.tajo.plan.LogicalPlanner.visitProjection(LogicalPlanner.java:67)
              at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:59)
              at org.apache.tajo.plan.LogicalPlanner.createPlan(LogicalPlanner.java:144)
              at org.apache.tajo.plan.LogicalPlanner.createPlan(LogicalPlanner.java:132)
              at org.apache.tajo.master.GlobalEngine.createLogicalPlan(GlobalEngine.java:233)
              at org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:162)
              at org.apache.tajo.master.TajoMasterClientService$TajoMasterClientProtocolServiceHandler.submitQuery(TajoMasterClientService.java:282)
              at org.apache.tajo.ipc.TajoMasterClientProtocol$TajoMasterClientProtocolService$2.callBlockingMethod(TajoMasterClientProtocol.java:543)
              at org.apache.tajo.rpc.BlockingRpcServer$ServerHandler.messageReceived(BlockingRpcServer.java:103)
              at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
              at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
              at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
              at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
              at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:70)
              at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
              at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
              at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
              at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)
              at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)
              at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)
              at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
              at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
              at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
              at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)
              at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)
              at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)
              at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109)
              at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312)
              at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90)
              at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
              at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
              at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
              at java.lang.Thread.run(Thread.java:745)
      ...
      

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user ykrips opened a pull request:

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

        TAJO-1316: NPE occurs when performing window functions after join

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

        $ git pull https://github.com/ykrips/tajo TAJO-1316

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

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


        commit 6aa644e112e40e6b9ab3481409cd176bb7781675
        Author: Jihun Kang <jihun@apache.org>
        Date: 2015-02-03T06:49:35Z

        Initial work

        commit cfc996dd37c3a15428ba2a26af9c56b48e4eddbf
        Author: Jihun Kang <jihun@apache.org>
        Date: 2015-02-03T06:49:59Z

        Merge remote-tracking branch 'upstream/master' into TAJO-1316


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user ykrips opened a pull request: https://github.com/apache/tajo/pull/372 TAJO-1316 : NPE occurs when performing window functions after join You can merge this pull request into a Git repository by running: $ git pull https://github.com/ykrips/tajo TAJO-1316 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/372.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 #372 commit 6aa644e112e40e6b9ab3481409cd176bb7781675 Author: Jihun Kang <jihun@apache.org> Date: 2015-02-03T06:49:35Z Initial work commit cfc996dd37c3a15428ba2a26af9c56b48e4eddbf Author: Jihun Kang <jihun@apache.org> Date: 2015-02-03T06:49:59Z Merge remote-tracking branch 'upstream/master' into TAJO-1316
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/372#issuecomment-72784630

        +1 ship it!

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/372#issuecomment-72784630 +1 ship it!
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/372#issuecomment-72794107

        Could you please commit it to both 0.10.0 branch and master branch?

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/372#issuecomment-72794107 Could you please commit it to both 0.10.0 branch and master branch?
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user ykrips commented on the pull request:

        https://github.com/apache/tajo/pull/372#issuecomment-72811884

        Sure. cherry-pick into branch-0.10.0.

        Show
        githubbot ASF GitHub Bot added a comment - Github user ykrips commented on the pull request: https://github.com/apache/tajo/pull/372#issuecomment-72811884 Sure. cherry-pick into branch-0.10.0.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

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

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

        SUCCESS: Integrated in Tajo-master-build #579 (See https://builds.apache.org/job/Tajo-master-build/579/)
        TAJO-1316: NPE occurs when performing window functions after join (jihun: rev 5e024f947b441fb49f5740deab119867eb655795)

        • tajo-core/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java
        • CHANGES
        • tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java
        • tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalTreeUtil.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #579 (See https://builds.apache.org/job/Tajo-master-build/579/ ) TAJO-1316 : NPE occurs when performing window functions after join (jihun: rev 5e024f947b441fb49f5740deab119867eb655795) tajo-core/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java CHANGES tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalTreeUtil.java
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #218 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/218/)
        TAJO-1316: NPE occurs when performing window functions after join (jihun: rev 5e024f947b441fb49f5740deab119867eb655795)

        • CHANGES
        • tajo-core/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java
        • tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java
        • tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalTreeUtil.java
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #218 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/218/ ) TAJO-1316 : NPE occurs when performing window functions after join (jihun: rev 5e024f947b441fb49f5740deab119867eb655795) CHANGES tajo-core/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java tajo-plan/src/main/java/org/apache/tajo/plan/LogicalPlanner.java tajo-plan/src/main/java/org/apache/tajo/plan/expr/EvalTreeUtil.java

          People

          • Assignee:
            ykrips Jihun Kang
            Reporter:
            jihoonson Jihoon Son
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development