[
https://issues.apache.org/jira/browse/SPARK-15122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
JESSE CHEN updated SPARK-15122:
-------------------------------
Affects Version/s: (was: 1.6.1)
2.0.0
> TPC-DS Qury 41 fails with The correlated scalar subquery can only contain
> equality predicates
> ---------------------------------------------------------------------------------------------
>
> Key: SPARK-15122
> URL: https://issues.apache.org/jira/browse/SPARK-15122
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: JESSE CHEN
>
> Hi I am testing on spark 2.0 but dont see an option to select it yet.
> TPC-DS query 23 fails with the compile error
> Error in query: NoViableAltException(-1@[237:51: ( KW_AS )?])
> line 4:33 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in subquery
> source
> ; line 4 pos 33
> I could narrow the error to an aggregation on a subquery.
> select max(csales) tpcds_cmax
> from (select sum(ss_quantity*ss_sales_price) csales
> from store_sales
> group by ss_customer_sk) ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
