Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4835

Add Median Function

    XMLWordPrintable

Details

    Description

      When analyzing skewed data, median can be a better measure than mean.

      Currently this can be implemented with a User Defined Function (e.g. http://www.mooreds.com/wordpress/archives/376), however this requires more overhead when upgrading and deploying database. This can also be handled with a query (e.g. http://stackoverflow.com/questions/1291152/simple-way-to-calculate-median-with-mysql), however that has a performance hit.

      Would adding a new aggregate function be possible?

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-12985 support percentile and median window functions

          • Major - Major loss of function.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-12987 complete window function support for columnstore parity

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-624 MariaDB 10.2 WF create MEDIAN, PERCENTILE_CONT and PERCENTILE_DISC Window functions

          • Major - Major loss of function.
          • Closed

          Activity

            People

              varun Varun Gupta (Inactive)
              BenHiles Ben Hiles (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.