[jira] [Commented] (SPARK-14292) TPC-DS Query 23 Fails with compile error

["Herman van Hovell (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-14292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15220042#comment-15220042 ] 

Herman van Hovell commented on SPARK-14292:
-------------------------------------------

It will probably work if you add an alias after the subquery.

> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org