[DRILL-2330] Add support for nested aggregate expressions for window aggregates

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.8.0
• Component/s: Query Planning & Optimization
• Assignee: Gautam Parai
• Reporter: Abhishek Girish
• Reviewer: Khurram Faraaz
• Created: 27/Feb/15 01:20
• Updated: 22/Aug/16 06:40
• Resolved: 14/Jul/16 22:30

Description

Aggregate expressions currently cannot be nested.

The following query fails to validate:

select avg(sum(i_item_sk)) from item;

Error:
Query failed: SqlValidatorException: Aggregate expressions cannot be nested

Log attached.

Reference: TPCDS queries (20, 63, 98, ...) fail to execute.

Issue Links

• links to: GitHub Pull Request #529