Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CFDE610590 for ; Mon, 7 Oct 2013 05:45:14 +0000 (UTC) Received: (qmail 31395 invoked by uid 500); 7 Oct 2013 05:44:07 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 31247 invoked by uid 500); 7 Oct 2013 05:43:38 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 31150 invoked by uid 99); 7 Oct 2013 05:43:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Oct 2013 05:43:28 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD,T_FRT_BELOW2 X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 07 Oct 2013 05:43:25 +0000 Received: (qmail 28716 invoked by uid 99); 7 Oct 2013 05:42:42 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Oct 2013 05:42:42 +0000 Date: Mon, 7 Oct 2013 05:42:42 +0000 (UTC) From: "Hyunsik Choi (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (TAJO-226) Can't use group by column alias MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TAJO-226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hyunsik Choi updated TAJO-226: ------------------------------ Resolution: Fixed Status: Resolved (was: Patch Available) committed the patch to master. Thank you for the review. > 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.(AggregationExec.java:86) > at org.apache.tajo.engine.planner.physical.HashAggregateExec.(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.(AggregationExec.java:86) > at org.apache.tajo.engine.planner.physical.HashAggregateExec.(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)