Dongkyu Hwangbo created TAJO-1772:
-------------------------------------
Summary: multipled window function should be supported
Key: TAJO-1772
URL: https://issues.apache.org/jira/browse/TAJO-1772
Project: Tajo
Issue Type: Improvement
Affects Versions: 0.11.0
Reporter: Dongkyu Hwangbo
Priority: Minor
tajo cannot run this query(in tpc-ds q20)
{code:SQL}
select i_item_id
,i_item_desc
,i_category
,i_class
,i_current_price
,sum(cs_ext_sales_price) as itemrevenue
,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over
(partition by i_class) as revenueratio
from catalog_sales
,item
,date_dim
where cs_item_sk = i_item_sk
and i_category in ('Sports', 'Books', 'Home')
and cs_sold_date_sk = d_date_sk
and d_date between cast('1999-02-22' as date)
and (cast('1999-02-22' as date) + 30)
group by i_item_id
,i_item_desc
,i_category
,i_class
,i_current_price
order by i_category
,i_class
,i_item_id
,i_item_desc
,revenueratio
limit 100;
{code}
but, remove this part, tajo gives me right answer
{code:SQL}
,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over (partition by
i_class) as revenueratio
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
