You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Mathew Wicks (JIRA)" <ji...@apache.org> on 2017/07/15 04:47:00 UTC

[jira] [Created] (SPARK-21423) MODE average aggregate function.

Mathew Wicks created SPARK-21423:
------------------------------------

             Summary: MODE average aggregate function.
                 Key: SPARK-21423
                 URL: https://issues.apache.org/jira/browse/SPARK-21423
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: Mathew Wicks
            Priority: Minor


Having a MODE() aggregate function which returns the mode average of a group/window would be very useful. 

For example, if the column type is a number, it finds the most common number, and if the column type is a string, it finds the most common string.

I appreciate that doing this in a scalable way will require some thinking/discussion.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org