[
https://issues.apache.org/jira/browse/TAJO-420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi resolved TAJO-420.
-------------------------------
Resolution: Cannot Reproduce
The bug was already fixed.
> 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.3.4#6332)
