[
https://issues.apache.org/jira/browse/KYLIN-2049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16521814#comment-16521814
]
Shaofeng SHI commented on KYLIN-2049:
-------------------------------------
Related with https://issues.apache.org/jira/browse/KYLIN-3359
> Incorrect AVG result with NULL measure values
> ---------------------------------------------
>
> Key: KYLIN-2049
> URL: https://issues.apache.org/jira/browse/KYLIN-2049
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Reporter: liyang
> Priority: Major
>
> Thanks to Itay. From -
> http://stackoverflow.com/questions/39664918/apache-kylin-null-value-measures-become-zeros
> I'm trying to build a Kylin Cube that will get me the Average of a SmallInt
> nullable column Col1. I expect any null value to not be counted towards this
> average. When I work on my table in Hive this is exactly the result that I'm
> getting when applying the AVG function. However when I build the cube in
> Kylin on top of this table all the null values in my measurements columns are
> becoming zeros and then counted towards the calculation of the AVG. Is there
> a way to force Kylin to treat nulls as nulls?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
