You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Yifei Wu (JIRA)" <ji...@apache.org> on 2018/05/29 12:43:00 UTC

[jira] [Created] (KYLIN-3392) support NULL value in Sum, Max, Min Aggregation

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)