You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "kim hyoung jun (JIRA)" <ji...@apache.org> on 2013/10/02 15:22:26 UTC
[jira] [Commented] (TAJO-228) Can't use group by column alias
[ https://issues.apache.org/jira/browse/TAJO-228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13783907#comment-13783907 ]
kim hyoung jun commented on TAJO-228:
-------------------------------------
Sorry. This is a duplicate of TAJO-226. Apache JIRA too slow, so submitted several times.
> 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)