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

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

Dongkyu Hwangbo created TAJO-1770:
-------------------------------------

             Summary: 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


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)