[jira] [Created] (TAJO-716) Using column names actually aliased in aggregation functions can cause planning error.

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

Hyunsik Choi created TAJO-716:
---------------------------------

             Summary: 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


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)