[ https://issues.apache.org/jira/browse/KYLIN-3392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16927598#comment-16927598 ]
ASF subversion and git services commented on KYLIN-3392: -------------------------------------------------------- Commit 1a2f779a074c1d03703eebbb7506d171ef26ce56 in kylin's branch refs/heads/master from Yifei Wu [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=1a2f779 ] Kylin 3392 support sum(null) * KYLIN-3392 support sum(null) * KYLIN-3392 support sum(null) * Minor, code review > 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 > Priority: Major > Fix For: v3.0.0, v2.6.4 > > > 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 (v8.3.2#803003)