You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "hongbin ma (JIRA)" <ji...@apache.org> on 2016/09/03 08:15:21 UTC
[jira] [Commented] (KYLIN-1630) incorrect sum(a)/sum(b) (how to get
the rate value)
[ https://issues.apache.org/jira/browse/KYLIN-1630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15460661#comment-15460661 ]
hongbin ma commented on KYLIN-1630:
-----------------------------------
for future reference, even if the data type is integer, we can workaround the issue by using 1.0* sum(a)/sum(b)
> incorrect sum(a)/sum(b) (how to get the rate value)
> ---------------------------------------------------
>
> Key: KYLIN-1630
> URL: https://issues.apache.org/jira/browse/KYLIN-1630
> Project: Kylin
> Issue Type: Bug
> Components: General
> Affects Versions: v1.5.1
> Environment: Kylin version:1.5.1
> Reporter: 陈雷雷
>
> I want to get a value which is defined as sum(a)/sum(b), how can I
> do this kind of anlysis.
> Kylin version:1.5.1
> Now I build a cube which have sum(a) and sum(b), when I execute
> “select sum(a)/sum(b) from table1 group by c” ,the result is wrong.
> sum(a)/sum(b) the result is all 0 and sum(b)/sum(a) result is all 1.
> MMENE_NAME SUCC ATT SUCC/ATT
> CSMME15BZX 336981 368366 1
> CSMME32BZX 338754 366842 1
> CSMME07BZX 687965 747694 1
> CSMME03BHW 703269 747623 1
> CSMME12BZX 705856 764656 1
> CSMME16BHW 1962293 142173 1
> MMENE_NAME SUCC ATT ATT/SUCC
> CSMME15BZX 336981 368366 0
> CSMME32BZX 338754 366842 0
> CSMME07BZX 687965 747694 0
> CSMME03BHW 703269 747623 0
> CSMME12BZX 705856 764656 0
> CSMME16BHW 1962293 142173 0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)