Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-13919

Calcite integration. Single group aggregates

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.15
    • sql
    • SQL Calcite: Added optimization for COUNT(column) if column is indexed
    • Docs Required, Release Notes Required

    Description

      Investigate the optimization for single group aggregates,
      e.g.: SELECT <aggregates> FROM <table>

      Now the hash based aggregates are used for this case.
      We can obtain a little performance improvement.
      Also the special cases (e.g.: SELECT COUNT(<any-columns>) FROM <table>) may be optimized to use table/cache size.

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-12248 Apache Calcite based query execution engine

          • Major - Major loss of function.
          • Open
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-16920 Calcite Engine. COUNT(*) lacks trivial optimization.

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #10390

          Activity

            People

              alex_pl Aleksey Plekhanov
              tledkov-gridgain Taras Ledkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h
                  3h