presto: Query failure with "Final aggregation with default value not separated from partial aggregation by remote hash exchange"
I get the error message “Final aggregation with default value not separated from partial aggregation by remote hash exchange” from https://github.com/prestodb/presto/blob/5dda212a416a9f04dff951e7ed45075998780749/presto-main/src/main/java/com/facebook/presto/sql/planner/sanity/ValidateAggregationsWithDefaultValues.java#L119
With the following minimized query example:
WITH query1 AS (SELECT a FROM table), query2 AS (SELECT a FROM query1 GROUP BY a) SELECT a FROM query2 GROUP BY GROUPING SETS ((a), ());
My actual query is larger, adding some calculations in query2 that depend on fields in query1, and then with filters in main select.
It seems that this should work. I’m running 0.206-146-gd3c9272f3d of Presto.
About this issue
- Original URL
- State: open
- Created 6 years ago
- Comments: 15 (8 by maintainers)
+1 on this, still seeing this too!