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