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 DA37A10E11 for ; Wed, 2 Oct 2013 13:14:49 +0000 (UTC) Received: (qmail 46270 invoked by uid 500); 2 Oct 2013 13:14:49 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 46195 invoked by uid 500); 2 Oct 2013 13:14:49 -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 46179 invoked by uid 99); 2 Oct 2013 13:14:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Oct 2013 13:14:48 +0000 X-ASF-Spam-Status: No, hits=-2000.6 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; Wed, 02 Oct 2013 13:14:46 +0000 Received: (qmail 45618 invoked by uid 99); 2 Oct 2013 13:14:24 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Oct 2013 13:14:24 +0000 Date: Wed, 2 Oct 2013 13:14:24 +0000 (UTC) From: "kim hyoung jun (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (TAJO-228) 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 kim hyoung jun created TAJO-228: ----------------------------------- Summary: Can't use group by column alias Key: TAJO-228 URL: https://issues.apache.org/jira/browse/TAJO-228 Project: Tajo Issue Type: Bug Reporter: kim hyoung jun 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 attached error message in tajo worker's log. -- This message was sent by Atlassian JIRA (v6.1#6144)