Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2330

Add support for nested aggregate expressions for window aggregates

VotersStop watchingWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.8.0
    • 1.8.0
    • Query Planning & Optimization
    • None

    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.

      Attachments

        1. drillbit.log
          11 kB
          Abhishek Girish

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            gparai Gautam Parai
            agirish Abhishek Girish
            Khurram Faraaz Khurram Faraaz
            Votes:
            0 Vote for this issue
            Watchers:
            6 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment