You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Seungun Choe (JIRA)" <ji...@apache.org> on 2013/12/16 06:58:06 UTC
[jira] [Created] (TAJO-420) TPC-H Q13 Does not workt.
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)