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:14:24 UTC

[jira] [Created] (TAJO-228) Can't use group by column alias

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)