[ https://issues.apache.org/jira/browse/TAJO-226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787926#comment-13787926
]
Hudson commented on TAJO-226:
-----------------------------
SUCCESS: Integrated in Tajo-trunk-postcommit #497 (See [https://builds.apache.org/job/Tajo-trunk-postcommit/497/])
TAJO-226: Can't use group by column alias. (hyunsik) (hyunsik: https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=e7f975710f1abff8fd3ebf10322e6fcafac18e0e)
* tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/Target.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/TargetListManager.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/logical/GroupbyNode.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java
* 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/rewrite/ProjectionPushDownRule.java
* tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestGroupByQuery.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
* CHANGES.txt
> Can't use group by column alias
> -------------------------------
>
> Key: TAJO-226
> URL: https://issues.apache.org/jira/browse/TAJO-226
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Reporter: kim hyoung jun
> Assignee: Hyunsik Choi
> Fix For: 0.2-incubating
>
> Attachments: TAJO-226_2.patch, TAJO-226.patch
>
>
> I ran the bellow query which uses column alias and group by.
> {code}
> select b.n_name as nation, count(*) as cnt
> from customer_100 a, nation_100 b
> where a.c_nationkey = b.n_nationkey
> group by b.n_name
> order by cnt desc
> limit 7
> {code}
> This query doesn't end. I found next error message in tajo worker's log.
> {code}
> 2013-10-02 21:41:21,804 INFO planner.PhysicalPlannerImpl (PhysicalPlannerImpl.java:createBestAggregationPlan(606))
- The planner chooses [Hash Aggregation]
> 2013-10-02 21:41:21,804 INFO planner.PhysicalPlannerImpl (PhysicalPlannerImpl.java:createInMemoryHashAggregation(558))
- The planner chooses [Hash Aggregation]
> 2013-10-02 21:41:21,808 ERROR worker.Task (Task.java:run(389)) - java.lang.ArrayIndexOutOfBoundsException:
1
> at org.apache.tajo.engine.planner.physical.AggregationExec.<init>(AggregationExec.java:86)
> at org.apache.tajo.engine.planner.physical.HashAggregateExec.<init>(HashAggregateExec.java:48)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createInMemoryHashAggregation(PhysicalPlannerImpl.java:559)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestAggregationPlan(PhysicalPlannerImpl.java:607)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createGroupByPlan(PhysicalPlannerImpl.java:553)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:148)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:152)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:169)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:74)
> at org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:47)
> at org.apache.tajo.worker.Task.run(Task.java:378)
> at org.apache.tajo.worker.TaskRunner$2.run(TaskRunner.java:364)
> at java.lang.Thread.run(Thread.java:662)
> 2013-10-02 21:41:21,808 INFO worker.Task (Task.java:run(434)) - Task Counter - total:11,
succeeded: 10, failed: 1
> 2013-10-02 21:41:21,808 INFO worker.TaskRunner (TaskRunner.java:run(307)) - Request
GetTask: eb_1380717656859_0001_000004,container_1380717656859_0001_01_000040
> 2013-10-02 21:41:21,809 ERROR querymaster.QueryUnitAttempt (QueryUnitAttempt.java:transition(312))
- FROM gruter104.gruter.com >> java.lang.ArrayIndexOutOfBoundsException: 1
> at org.apache.tajo.engine.planner.physical.AggregationExec.<init>(AggregationExec.java:86)
> at org.apache.tajo.engine.planner.physical.HashAggregateExec.<init>(HashAggregateExec.java:48)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createInMemoryHashAggregation(PhysicalPlannerImpl.java:559)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestAggregationPlan(PhysicalPlannerImpl.java:607)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createGroupByPlan(PhysicalPlannerImpl.java:553)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:148)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:152)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:169)
> at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:74)
> at org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:47)
> at org.apache.tajo.worker.Task.run(Task.java:378)
> at org.apache.tajo.worker.TaskRunner$2.run(TaskRunner.java:364)
> at java.lang.Thread.run(Thread.java:662)
> 2013-10-02 21:41:21,809 INFO event.TaskScheduleEvent (TaskSchedulerImpl.java:handle(232))
- TaskRequest: container_1380717656859_0001_01_000040,eb_1380717656859_0001_000004
> 2013-10-02 21:41:21,809 INFO querymaster.QueryUnit (QueryUnit.java:transition(432))
- =============================================================
> 2013-10-02 21:41:21,810 INFO querymaster.QueryUnit (QueryUnit.java:transition(433))
- >>> Task Failed: ta_1380717656859_0001_000004_000000_00 <<<
> 2013-10-02 21:41:21,810 INFO querymaster.QueryUnit (QueryUnit.java:transition(434))
- =============================================================
> {code}
--
This message was sent by Atlassian JIRA
(v6.1#6144)
|