kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yifei Wu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (KYLIN-3392) support NULL value in Sum, Max, Min Aggregation
Date Wed, 30 May 2018 06:57:00 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-3392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16494768#comment-16494768
] 

Yifei Wu edited comment on KYLIN-3392 at 5/30/18 6:56 AM:
----------------------------------------------------------

[~albertoramon] you mean this issue KYLIN_2049 [KYLIN-2049|https://issues.apache.org/jira/browse/KYLIN-2049]


was (Author: yifei_wu94):
[~albertoramon] you mean this issue KYLIN_2049

> 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
>
> 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)

Mime
View raw message