[SPARK-5680] Sum function on all null values, should return zero

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.1, 1.4.0
• Component/s: SQL
• Target Version/s: 1.4.0
• Assignee: Venkata Gollamudi
• Reporter: Venkata Gollamudi
• Created: 09/Feb/15 07:27
• Updated: 26/Jul/15 04:19
• Resolved: 21/Mar/15 20:25

Description

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

Issue Links

• breaks: SPARK-8828 Revert the change of SPARK-5680
• links to: [Github] Pull Request #4466 (gvramana)
• links to: [Github] Pull Request #7667 (yjshen)