[ https://issues.apache.org/jira/browse/SPARK-14763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15250530#comment-15250530 ]
Herman van Hovell commented on SPARK-14763: ------------------------------------------- [~davies] are you fixing this one? > 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: Davies Liu > > {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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org