tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Seungun Choe (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-420) TPC-H Q13 Does not workt.
Date Mon, 16 Dec 2013 05:58:06 GMT
Seungun Choe created TAJO-420:
---------------------------------

             Summary: TPC-H Q13 Does not workt.
                 Key: TAJO-420
                 URL: https://issues.apache.org/jira/browse/TAJO-420
             Project: Tajo
          Issue Type: Bug
            Reporter: Seungun Choe


{code}
2013-12-16 14:54:29,788 INFO  master.GlobalEngine (GlobalEngine.java:executeQuery(109)) -
SQL: select
  c_count, count(1) as custdist
from
  (select
     c_custkey, count(o_orderkey) as c_count
   from
     customer_rc_snappy c left outer join orders_rc_snappy o
     on
       c.c_custkey = o.o_custkey and not o.o_comment like '%special%requests%'
   group by c_custkey
   ) c_orders
group by c_count
order by custdist desc, c_count desc
2013-12-16 14:54:29,788 INFO  master.GlobalEngine (GlobalEngine.java:executeQuery(128)) -
hive.query.mode:false
2013-12-16 14:54:29,804 ERROR master.GlobalEngine (GlobalEngine.java:executeQuery(172)) -
Stack Trace:
org.apache.tajo.engine.exception.InvalidQueryException: Incorrect Logical Query Plan with
regard to outer join
        at org.apache.tajo.engine.planner.rewrite.FilterPushDownRule.visitJoin(FilterPushDownRule.java:133)
        at org.apache.tajo.engine.planner.rewrite.FilterPushDownRule.visitJoin(FilterPushDownRule.java:38)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitChild(BasicLogicalPlanVisitor.java:78)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitGroupBy(BasicLogicalPlanVisitor.java:154)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitChild(BasicLogicalPlanVisitor.java:72)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitProjection(BasicLogicalPlanVisitor.java:127)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitChild(BasicLogicalPlanVisitor.java:63)
        at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:48)
        at org.apache.tajo.engine.planner.rewrite.FilterPushDownRule.rewrite(FilterPushDownRule.java:59)
        at org.apache.tajo.engine.planner.rewrite.BasicQueryRewriteEngine.rewrite(BasicQueryRewriteEngine.java:63)
        at org.apache.tajo.engine.planner.LogicalOptimizer.optimize(LogicalOptimizer.java:61)
        at org.apache.tajo.master.GlobalEngine.createLogicalPlan(GlobalEngine.java:221)
at org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:136)
        at org.apache.tajo.master.TajoMasterClientService$TajoMasterClientProtocolServiceHandler.submitQuery(TajoMasterClientService.java:135)
        at org.apache.tajo.ipc.TajoMasterClientProtocol$TajoMasterClientProtocolService$2.callBlockingMethod(TajoMasterClientProtocol.java:215)
        at org.apache.tajo.rpc.BlockingRpcServer$ServerHandler.messageReceived(BlockingRpcServer.java:91)
        at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
        at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
        at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:76)
        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
        at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
        at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
        at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
        at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
        at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540)
        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)
        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)
        at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:349)
{code}

plz check this issue;



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Mime
View raw message