Davies Liu created SPARK-14763:
----------------------------------
Summary: Can't analyze TPCDS Q70
Key: SPARK-14763
URL: https://issues.apache.org/jira/browse/SPARK-14763
Project: Spark
Issue Type: Bug
Components: SQL
Reporter: Davies Liu
Assignee: Herman van Hovell
{code}
select
sum(ss_net_profit) as total_sum, s_state, s_county
,grouping(s_state)+grouping(s_county) as lochierarchy
,rank() over (
partition by grouping(s_state)+grouping(s_county),
case when grouping(s_county) = 0 then s_state end
order by sum(ss_net_profit) desc) as rank_within_parent
from
store_sales, date_dim d1, store
where
d1.d_month_seq between 1200 and 1200+11
and d1.d_date_sk = ss_sold_date_sk
and s_store_sk = ss_store_sk
and s_state in
(select s_state from
(select s_state as s_state,
rank() over ( partition by s_state order by
sum(ss_net_profit) desc) as ranking
from store_sales, store, date_dim
where d_month_seq between 1200 and 1200+11
and d_date_sk = ss_sold_date_sk
and s_store_sk = ss_store_sk
group by s_state) tmp1
where ranking <= 5)
group by rollup(s_state,s_county)
order by
lochierarchy desc
,case when lochierarchy = 0 then s_state end
,rank_within_parent
limit 100
{code}
Error
{code}
ERR u'Accessing outer query column is not allowed in an AGGREATE:
d_month_seq#158;'
{code}
The column d_month_seq inside subquery does not reference to outer table, it's
not resolved correctly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
