-
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
-
Labels:None
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.
- links to