[jira] [Commented] (TAJO-1756) Scalar expressions after aggregation should be supported.

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-1756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14695081#comment-14695081 ] 

Hyunsik Choi commented on TAJO-1756:
------------------------------------

I've changed the title into the better one.

> Scalar expressions after aggregation should be supported.
> ---------------------------------------------------------
>
>                 Key: TAJO-1756
>                 URL: https://issues.apache.org/jira/browse/TAJO-1756
>             Project: Tajo
>          Issue Type: Wish
>          Components: Benchmark
>            Reporter: Dongkyu Hwangbo
>            Priority: Minor
>              Labels: sql
>
> in TPC-DS q54
> cannot run this query in tajo with internal error 
> {code:SQL}
> select segment, count(*) as num_customers, segment*50 as segment_base
> from segments
> group by segment
> order by segment, num_customers ;
> {code}
> to run above query, modify a little bit
> {code:SQL}
> select s, num_customers, s *50 as segment_base
> from
> (select segment as s, count(*) as num_customers
> from segments
> group by segment
> order by segment, num_customers) a;
> {code}
> this process is inefficient. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)