[jira] [Created] (TAJO-1756) 'after GROUP BY' Process optimization is required

["Dongkyu Hwangbo (JIRA)" <ji...@apache.org>]

Dongkyu Hwangbo created TAJO-1756:
-------------------------------------

             Summary: 'after GROUP BY' Process optimization is required
                 Key: TAJO-1756
                 URL: https://issues.apache.org/jira/browse/TAJO-1756
             Project: Tajo
          Issue Type: Wish
          Components: Benchmark
            Reporter: Dongkyu Hwangbo
            Priority: Minor


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)