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 >
