Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Incomplete
-
1.6.0, 2.0.0
-
None
Description
Spark SQL is unable to resolve the following query.
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)
We need to push down the aggregate functions in Sort into Aggregate.