You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Dongkyu Hwangbo (JIRA)" <ji...@apache.org> on 2015/08/17 03:43:45 UTC
[jira] [Updated] (TAJO-1772) multipled window function should be
supported
[ https://issues.apache.org/jira/browse/TAJO-1772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dongkyu Hwangbo updated TAJO-1772:
----------------------------------
Description:
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 can run query
{code:SQL}
,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over (partition by i_class) as revenueratio
{code}
was:
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}
> 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
> Labels: sql
>
> 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 can run query
> {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)