Xiao Li created SPARK-13428:
-------------------------------
Summary: Pushdown Aggregate Functions in Sort into Aggregate
Key: SPARK-13428
URL: https://issues.apache.org/jira/browse/SPARK-13428
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.6.0, 2.0.0
Reporter: Xiao Li
Spark SQL is unable to resolve the following query.
{{code}}
sql(
"""
|select area, sum(product) over () as c from windowData
|where product > 3 group by area, product
|having avg(month) > 0 order by area, avg(month), product
""".stripMargin)
{{code}}
We need to push down the aggregate functions in Sort into Aggregate.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
