[ 
https://issues.apache.org/jira/browse/SPARK-11371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14985433#comment-14985433
 ] 

Sean Owen commented on SPARK-11371:
-----------------------------------

I don't feel strongly about it, and it's not really my area. My instinct is to 
not support keywords that are generally not supported in SQL dialects, in 
Spark's SQL dialect, if possible. 

> Make "mean" an alias for "avg" operator
> ---------------------------------------
>
>                 Key: SPARK-11371
>                 URL: https://issues.apache.org/jira/browse/SPARK-11371
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Ted Yu
>            Priority: Minor
>         Attachments: spark-11371-v1.patch
>
>
> From Reynold in the thread 'Exception when using some aggregate operators'  
> (http://search-hadoop.com/m/q3RTt0xFr22nXB4/):
> I don't think these are bugs. The SQL standard for average is "avg", not 
> "mean". Similarly, a distinct count is supposed to be written as 
> "count(distinct col)", not "countDistinct(col)".
> We can, however, make "mean" an alias for "avg" to improve compatibility 
> between DataFrame and SQL.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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

Reply via email to