[
https://issues.apache.org/jira/browse/SPARK-14968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
JESSE CHEN updated SPARK-14968:
---
Description:
This is a regression from a week ago. Failed to generate plan for query 1 in
TPCDS using 0427 build from
people.apache.org/~pwendell/spark-nightly/spark-master-bin/latest/.
Was working in build from 0421.
The error is:
{noformat}
16/04/27 07:00:59 INFO spark.SparkContext: Created broadcast 3 from processCmd
at CliDriver.java:376
16/04/27 07:00:59 INFO datasources.FileSourceStrategy: Planning scan with bin
packing, max size: 4194304 bytes, open cost is considered as scanning 4194304
bytes.
Error in query: resolved attribute(s) ctr_store_sk#2#535 missing from
ctr_store_sk#2,ctr_total_return#3 in operator !Filter (ctr_store_sk#2#535 =
ctr_store_sk#2);
16/04/27 07:00:59 INFO handler.ContextHandler: stopped
o.s.j.s.ServletContextHandler{/static/sql,null}
16/04/27 07:00:59 INFO handler.ContextHandler: stopped
o.s.j.s.ServletContextHandler{/SQL/execution/json,null}
{noformat}
The query is:
{noformat}
(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
{noformat}
was:
This is a regression from a week ago. Failed to generate plan for query 1 in
TPCDS using 0427 build from
people.apache.org/~pwendell/spark-nightly/spark-master-bin/latest/.
Was working in
> TPC-DS query 1 fails to generate plan
> -
>
> Key: SPARK-14968
> URL: https://issues.apache.org/jira/browse/SPARK-14968
> Project: Spark
> Issue Type: Bug
>Affects Versions: 2.0.0
>Reporter: JESSE CHEN
>Priority: Critical
>
> This is a regression from a week ago. Failed to generate plan for query 1 in
> TPCDS using 0427 build from
> people.apache.org/~pwendell/spark-nightly/spark-master-bin/latest/.
> Was working in build from 0421.
> The error is:
> {noformat}
> 16/04/27 07:00:59 INFO spark.SparkContext: Created broadcast 3 from
> processCmd at CliDriver.java:376
> 16/04/27 07:00:59 INFO datasources.FileSourceStrategy: Planning scan with bin
> packing, max size: 4194304 bytes, open cost is considered as scanning 4194304
> bytes.
> Error in query: resolved attribute(s) ctr_store_sk#2#535 missing from
> ctr_store_sk#2,ctr_total_return#3 in operator !Filter (ctr_store_sk#2#535 =
> ctr_store_sk#2);
> 16/04/27 07:00:59 INFO handler.ContextHandler: stopped
> o.s.j.s.ServletContextHandler{/static/sql,null}
> 16/04/27 07:00:59 INFO handler.ContextHandler: stopped
> o.s.j.s.ServletContextHandler{/SQL/execution/json,null}
> {noformat}
> The query is:
> {noformat}
> (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
> {noformat}
--
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
