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

Sql. Align implementations of average calculation (AVG)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 3.0
    • sql
    • Docs Required, Release Notes Required

    Description

      We have Map/Reduce and Collocated algorithms of implementations for calculation average values.
      At least for the DECIMAL type we have different implementations which can produce different precision/scale of results and value of results.

      We need to do the following:
      1) Check implementations of AVG for all types and align them, including resolving types of results.
      2) The result type of AVG in the plan and the real result type after execution should be identical.

      Points to start investigate:

      1. ItAggregatesTest
      2. AccumulatorsFactory
      3. IgniteSqlFunctions#decimalDivide
      4. MapReduceAggregates#createAvgAgg

      Attachments

        Issue Links

          Activity

            People

              amashenkov Andrey Mashenkov
              jooger Iurii Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 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 - 2h 10m
                  2h 10m