You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yin Huai (JIRA)" <ji...@apache.org> on 2015/07/06 05:40:04 UTC
[jira] [Commented] (SPARK-5680) Sum function on all null values,
should return zero
[ https://issues.apache.org/jira/browse/SPARK-5680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14614508#comment-14614508 ]
Yin Huai commented on SPARK-5680:
---------------------------------
https://issues.apache.org/jira/browse/HIVE-861 is the issue added the test of "udaf_number_format.q". I believe that returning "0.0" for sum('a') is a bug (the description of the issue indeed mentioned that sum('a') should return null).
> Sum function on all null values, should return zero
> ---------------------------------------------------
>
> Key: SPARK-5680
> URL: https://issues.apache.org/jira/browse/SPARK-5680
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Venkata Ramana G
> Assignee: Venkata Ramana G
> Priority: Minor
> Fix For: 1.3.1, 1.4.0
>
>
> SELECT sum('a'), avg('a'), variance('a'), std('a') FROM src;
> Current output:
> NULL NULL NULL NULL
> Expected output:
> 0.0 NULL NULL NULL
> This fixes hive udaf_number_format.q
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org