[
https://issues.apache.org/jira/browse/DRILL-2330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338563#comment-15338563
]
ASF GitHub Bot commented on DRILL-2330:
---------------------------------------
GitHub user gparai opened a pull request:
https://github.com/apache/drill/pull/529
[DRILL-2330] Add support for nested aggregates in Drill
This is the second part of the commit which adds nested aggregate tests in
Drill using Drill Calcite r12. The first part of the commit added support for
nested aggregates in Drill's forked version of Calcite. Please take a look.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gparai/drill Drill-2330-ADM
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/529.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #529
----
commit d6e2e8ded041d537345db2aad40da0a133ea2841
Author: Gautam Parai <[email protected]>
Date: 2016-06-18T01:13:15Z
[DRILL-2330] Add equivalent for tests for Drill
----
> Add support for nested aggregate expressions for window aggregates
> ------------------------------------------------------------------
>
> Key: DRILL-2330
> URL: https://issues.apache.org/jira/browse/DRILL-2330
> Project: Apache Drill
> Issue Type: Improvement
> Components: Query Planning & Optimization
> Affects Versions: 0.8.0
> Reporter: Abhishek Girish
> Assignee: Gautam Kumar Parai
> Fix For: Future
>
> Attachments: drillbit.log
>
>
> Aggregate expressions currently cannot be nested.
> *The following query fails to validate:*
> {code:sql}
> select avg(sum(i_item_sk)) from item;
> {code}
> Error:
> Query failed: SqlValidatorException: Aggregate expressions cannot be nested
> Log attached.
> Reference: TPCDS queries (20, 63, 98, ...) fail to execute.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
