You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Keuntae Park (JIRA)" <ji...@apache.org> on 2014/03/27 01:56:15 UTC
[jira] [Commented] (TAJO-716) Using column names actually aliased
in aggregation functions can cause planning error.
[ https://issues.apache.org/jira/browse/TAJO-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948717#comment-13948717 ]
Keuntae Park commented on TAJO-716:
-----------------------------------
+1
it works well!
> Using column names actually aliased in aggregation functions can cause planning error.
> --------------------------------------------------------------------------------------
>
> Key: TAJO-716
> URL: https://issues.apache.org/jira/browse/TAJO-716
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Affects Versions: 0.8-incubating, 1.0-incubating
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.8-incubating, 1.0-incubating
>
> Attachments: TAJO-716.patch
>
>
> The below query can cause the following error.
> {code}
> select
> nation.n_nationkey as n_nationkey,
> customer.c_name as c_name,
> count(nation.n_nationkey) as cnt
> from
> nation inner join customer on n_nationkey = c_nationkey
> group by
> nation.n_nationkey,
> customer.c_name
> order by
> n_nationkey, c_name;
> {code}
> {noformat}
> Stack Trace:
> org.apache.tajo.engine.planner.PlanningException: Cannot expect a referenced relation: n_nationkey (INT4)
> at org.apache.tajo.engine.planner.logical.join.JoinGraph.guessRelationsFromJoinQual(JoinGraph.java:59)
> at org.apache.tajo.engine.planner.logical.join.JoinGraph.addJoin(JoinGraph.java:92)
> at org.apache.tajo.engine.planner.LogicalOptimizer$JoinGraphBuilder.visitJoin(LogicalOptimizer.java:165)
> at org.apache.tajo.engine.planner.LogicalOptimizer$JoinGraphBuilder.visitJoin(LogicalOptimizer.java:133)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:81)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitGroupBy(BasicLogicalPlanVisitor.java:176)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:75)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitSort(BasicLogicalPlanVisitor.java:158)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:69)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitProjection(BasicLogicalPlanVisitor.java:140)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:63)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visitRoot(BasicLogicalPlanVisitor.java:130)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:58)
> at org.apache.tajo.engine.planner.BasicLogicalPlanVisitor.visit(BasicLogicalPlanVisitor.java:45)
> at org.apache.tajo.engine.planner.LogicalOptimizer$JoinGraphBuilder.buildJoinGraph(LogicalOptimizer.java:148)
> at org.apache.tajo.engine.planner.LogicalOptimizer.optimizeJoinOrder(LogicalOptimizer.java:86)
> at org.apache.tajo.engine.planner.LogicalOptimizer.optimize(LogicalOptimizer.java:71)
> at org.apache.tajo.master.GlobalEngine.createLogicalPlan(GlobalEngine.java:260)
> at org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:138)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)