[
https://issues.apache.org/jira/browse/TAJO-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948867#comment-13948867
]
Hudson commented on TAJO-716:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #137 (See
[https://builds.apache.org/job/Tajo-master-build/137/])
TAJO-716: Using column names actually aliased in aggregation functions can
cause planning error. (hyunsik: rev b1e0e3499e2459e58b2cede4f4268ad26d3ed7d4)
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/RelationNode.java
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAlias2.result
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestSortQuery/testSortWithAlias3.sql
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/ExprNormalizer.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/NamedExprsManager.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/join/JoinGraph.java
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestSortQuery/testSortWithAlias2.sql
* CHANGES.txt
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAlias3.result
*
tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestSortQuery.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/ScanNode.java
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAscDescKeys.result
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/TableSubQueryNode.java
> 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)
