Fabian Hueske created FLINK-3971: ------------------------------------ Summary: Aggregates handle null values incorrectly. Key: FLINK-3971 URL: https://issues.apache.org/jira/browse/FLINK-3971 Project: Flink Issue Type: Bug Components: Table API Affects Versions: 1.1.0 Reporter: Fabian Hueske Priority: Critical Fix For: 1.1.0
Table API and SQL aggregates are supposed to ignore null values, e.g., {{sum(1,2,null,4)}} is supposed to return {{7}}. There current implementation is correct if at least one valid value is present however, is incorrect if only null values are aggregated. {{sum(null, null, null)}} should return {{null}} instead of {{0}} Currently only the Count aggregate handles the case of null-values-only correctly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)