I think it's still worth a JIRA: https://issues.apache.org/jira/browse/KYLIN-1690
On Sun, May 15, 2016 at 11:43 PM, hongbin ma <mahong...@apache.org> wrote: > for integer metrics, a quick workaround is to modify sum(b)/sum(a) to > 1.0*sum(b)/sum(a) > > On Sun, May 8, 2016 at 8:26 PM, Li Yang <liy...@apache.org> wrote: > >> Thanks for the update. >> >> On Thu, May 5, 2016 at 2:57 PM, 耳东 <775620...@qq.com> wrote: >> >> > The datatype is bigint. This problem is solved, when I change to double. >> > >> > >> > ------------------ 原始邮件 ------------------ >> > 发件人: "耳东";<775620...@qq.com>; >> > 发送时间: 2016年4月27日(星期三) 下午5:46 >> > 收件人: "dev"<dev@kylin.apache.org>; >> > >> > 主题: 回复: how to get the rate value >> > >> > >> > >> > the Kylin version is added in the description. >> > >> > >> > >> > >> > ------------------ 原始邮件 ------------------ >> > 发件人: "Li Yang";<liy...@apache.org>; >> > 发送时间: 2016年4月27日(星期三) 下午5:07 >> > 收件人: "dev"<dev@kylin.apache.org>; >> > >> > 主题: Re: how to get the rate value >> > >> > >> > >> > Please provide the Kylin version in the JIRA. >> > >> > On Wed, Apr 27, 2016 at 1:04 PM, ShaoFeng Shi <shaofeng...@apache.org> >> > wrote: >> > >> > > hi dong, could you please open a JIRA to Kylin for tracking this >> issue? >> > > https://issues.apache.org/jira/secure/Dashboard.jspa >> > > >> > > Thanks! >> > > >> > > 2016-04-26 20:56 GMT+08:00 耳东 <775620...@qq.com>: >> > > >> > > > Hi all: >> > > > >> > > > >> > > > I want to get a value which is defined as sum(a)/sum(b), how >> can >> > I >> > > > do this kind of anlysis. >> > > > >> > > > 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 >> > > >> > > >> > > >> > > >> > > -- >> > > Best regards, >> > > >> > > Shaofeng Shi >> > > >> > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > Apache Kylin: http://kylin.io > Github: https://github.com/binmahone > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone