[TAJO-1756] Scalar expressions after aggregation should be supported.

• Type: Wish
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Benchmark
• Labels: sql
• Assignee: Unassigned
• Reporter: Dongkyu Hwangbo
• Created: 13/Aug/15 08:06
• Updated: 13/Aug/15 11:33

Description

in TPC-DS q54

cannot run this query in tajo with internal error

select segment, count(*) as num_customers, segment*50 as segment_base
from segments
group by segment
order by segment, num_customers ;

to run above query, modify a little bit

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;

this process is inefficient.