kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (KYLIN-2049) Incorrect AVG result with NULL measure values
Date Fri, 14 Sep 2018 01:53:00 GMT

     [ https://issues.apache.org/jira/browse/KYLIN-2049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Shaofeng SHI resolved KYLIN-2049.
---------------------------------
       Resolution: Fixed
    Fix Version/s: v2.4.0

Kylin 2.4 fixed this problem by translate count(A) to sum(case A is null then 0 else 1 end).
You need to define A as a dimension.

> 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
>             Fix For: v2.4.0
>
>
> 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)

Mime
View raw message