Yifei Wu created KYLIN-3392:
-------------------------------

             Summary: support NULL value in Sum, Max, Min Aggregation
                 Key: KYLIN-3392
                 URL: https://issues.apache.org/jira/browse/KYLIN-3392
             Project: Kylin
          Issue Type: Bug
            Reporter: Yifei Wu
            Assignee: Yifei Wu


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to