tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kim hyoung jun (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-228) Can't use group by column alias
Date Wed, 02 Oct 2013 13:22:26 GMT

    [ 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)

Mime
View raw message