drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2330) Add support for nested aggregate expressions for window aggregates
Date Sun, 19 Jun 2016 15:21:05 GMT

    [ 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 <gparai@maprtech.com>
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)

Mime
View raw message