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