skambha commented on issue #27627: URL: https://github.com/apache/spark/pull/27627#issuecomment-617987912
>Nulls should be skipped when calculating aggregate functions. Yes, that is handled with the logic in the Sum. This exists today and we do not change any of that behavior. The specific scenario I mentioned earlier is when you are doing a sum of all nulls and the issue comes from the algorithm in this comment. https://github.com/apache/spark/pull/27627#issuecomment-597440834 Apart from the explicit test case that is added and I pointed to, there is a similar one as an example for Sum function description. ` > SELECT _FUNC_(col) FROM VALUES (NULL), (NULL) AS tab(col);` and the expected output is NULL. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
