Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6427

Use a higher precision for DECIMAL intermediate results for some aggregate functions like STDDEV

    XMLWordPrintableJSON

Details

    Description

      Today aggregates like STDDEV are expanded into computations that use intermediate results with the same type as the input values. Since STDDEV squares values, this precision may prove insufficient. For DECIMAL values a reasonable approach would be to use double the input precision and scale.

      This is also related to CALCITE-6322, CALCITE-4924, CALCITE-6324

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: