[jira] [Reopened] (TAJO-1770) WITH clause should be supported

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

     [ https://issues.apache.org/jira/browse/TAJO-1770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dongkyu Hwangbo reopened TAJO-1770:
-----------------------------------

> WITH clause should be supported
> -------------------------------
>
>                 Key: TAJO-1770
>                 URL: https://issues.apache.org/jira/browse/TAJO-1770
>             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 q1)
> {code:SQL}
> with 
> 	customer_total_return
> as (
> 	select
> 		 sr_customer_sk as ctr_customer_sk
> 		,sr_store_sk as ctr_store_sk
> 		,sum(SR_RETURN_AMT) as ctr_total_return
> 	from 
> 		store_returns
> 		,date_dim
> 	where 
> 		sr_returned_date_sk = d_date_sk
> 		and d_year =2000
> 	group by 
> 		sr_customer_sk
> 		,sr_store_sk)
> select 	
> 	c_customer_id
> from 
> 	customer_total_return ctr1
> 	,store
> 	,customer
> where 
> 	ctr1.ctr_total_return > (
> 		select 
> 			avg(ctr_total_return)*1.2
> 		from 
> 			customer_total_return ctr2
> 		where 
> 			ctr1.ctr_store_sk = ctr2.ctr_store_sk)
> 	and s_store_sk = ctr1.ctr_store_sk
> 	and s_state = 'TN'
> 	and ctr1.ctr_customer_sk = c_customer_sk
> order by 
> 	c_customer_id
> limit 100;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)