Roy Cecil created SPARK-14292:
---------------------------------
Summary: TPC-DS Query 23 Fails with compile error
Key: SPARK-14292
URL: https://issues.apache.org/jira/browse/SPARK-14292
Project: Spark
Issue Type: Bug
Affects Versions: 1.6.1
Reporter: Roy Cecil
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]