You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "nichunen (Jira)" <ji...@apache.org> on 2020/01/21 07:44:02 UTC
[jira] [Closed] (KYLIN-3946) No cube for AVG measure after include
count column
[ https://issues.apache.org/jira/browse/KYLIN-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
nichunen closed KYLIN-3946.
---------------------------
Resolved in release v3.0.0-alpha2(2019-07-31)
> No cube for AVG measure after include count column
> --------------------------------------------------
>
> Key: KYLIN-3946
> URL: https://issues.apache.org/jira/browse/KYLIN-3946
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.6.1
> Reporter: Chao Long
> Assignee: Chao Long
> Priority: Major
> Fix For: v3.0.0-alpha2
>
>
> Before, avg(col) will use sum(col)/count(1) to calculate.
> After including count column aggregation KYLIN-3883, avg(col) will use sum(col)/count(col) to calculate.
> If there is no predefined count(col) measure, query with avg(col) will get exception "NoRealizationFoundException: No realization found for OLAPContext", which will effect the query on old cubes. So we should consider compatibility.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)