[CALCITE-750] Allow windowed aggregate on top of regular aggregate

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0-incubating
• Fix Version/s: 1.8.0
• Assignee: Julian Hyde
• Reporter: Aman Sinha
• Created: 03/Jun/15 17:10
• Updated: 25/Jul/16 05:27
• Resolved: 05/Jun/16 22:29

Description

Window aggregate on top of a regular aggregate expression is a valid query but currently fails with a 'aggregate expression cannot be nested' error.

SELECT avg(sum(sal)) over (partition by deptno) from emp group by deptno;

SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Aggregate expressions cannot be nested

We should allow one level nesting of aggregates under window aggregates, i.e. window_agg(regular_agg(args)) over window.

Issue Links

• relates to: CALCITE-1327 Nested aggregate windowed query fails