[jira] [Updated] (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:all-tabpanel ]

Hyunsik Choi updated TAJO-1756:
-------------------------------
    Summary: Scalar expressions after aggregation should be supported.  (was: 'after GROUP BY' Process optimization is required)

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