[KYLIN-3392] Support NULL value in Sum, Max, Min Aggregation

• Type: Bug
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Assignee: Yifei Wu
• Reporter: Yifei Wu
• Created: 29/May/18 12:42
• Updated: 30/Dec/20 12:59

Description

It is treated as 0 when confronted with NULL value in KYLIN's basic aggregate measure (like sum, max, min). However, to distinguish the NULL value with 0 is very necessary.

It should be like this

sum(null, null) = null

sum(null, 1) = 1

max(null, null) = null

max(null, -1) = -1

min(null, -1）= -1

 in accordance with Hive and SparkSQL

Issue Links

• relates to: KYLIN-2049 Incorrect AVG result with NULL measure values