Re: how to get the rate value
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 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 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"; >> > >> > 主题: 回复: how to get the rate value >> > >> > >> > >> > the Kylin version is added in the description. >> > >> > >> > >> > >> > -- 原始邮件 -- >> > 发件人: "Li Yang";; >> > 发送时间: 2016年4月27日(星期三) 下午5:07 >> > 收件人: "dev"; >> > >> > 主题: 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 >> > 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_NAMESUCC ATTSUCC/ATT >> > > > CSMME15BZX 336981 368366 1 >> > > > CSMME32BZX 338754 366842 1 >> > > > CSMME07BZX 687965 747694 1 >> > > > CSMME03BHW 703269 747623 1 >> > > > CSMME12BZX 705856 764656 1 >> > > > CSMME16BHW 1962293142173 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 1962293142173 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
Re: how to get the rate value
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 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"; > > > > 主题: 回复: how to get the rate value > > > > > > > > the Kylin version is added in the description. > > > > > > > > > > -- 原始邮件 -- > > 发件人: "Li Yang";; > > 发送时间: 2016年4月27日(星期三) 下午5:07 > > 收件人: "dev"; > > > > 主题: 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 > > 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_NAMESUCC ATTSUCC/ATT > > > > CSMME15BZX 336981 368366 1 > > > > CSMME32BZX 338754 366842 1 > > > > CSMME07BZX 687965 747694 1 > > > > CSMME03BHW 703269 747623 1 > > > > CSMME12BZX 705856 764656 1 > > > > CSMME16BHW 1962293142173 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 1962293142173 0 > > > > > > > > > > > > > > > -- > > > Best regards, > > > > > > Shaofeng Shi > > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
Re: how to get the rate value
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"; > > 主题: 回复: how to get the rate value > > > > the Kylin version is added in the description. > > > > > -- 原始邮件 -------------- > 发件人: "Li Yang";; > 发送时间: 2016年4月27日(星期三) 下午5:07 > 收件人: "dev"; > > 主题: 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 > 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_NAMESUCC ATTSUCC/ATT > > > CSMME15BZX 336981 368366 1 > > > CSMME32BZX 338754 366842 1 > > > CSMME07BZX 687965 747694 1 > > > CSMME03BHW 703269 747623 1 > > > CSMME12BZX 705856 764656 1 > > > CSMME16BHW 1962293142173 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 1962293142173 0 > > > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi > >
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 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_NAMESUCC ATTSUCC/ATT > > CSMME15BZX 336981 368366 1 > > CSMME32BZX 338754 366842 1 > > CSMME07BZX 687965 747694 1 > > CSMME03BHW 703269 747623 1 > > CSMME12BZX 705856 764656 1 > > CSMME16BHW 1962293142173 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 1962293142173 0 > > > > > -- > Best regards, > > Shaofeng Shi >
Re: how to get the rate value
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_NAMESUCC ATTSUCC/ATT > CSMME15BZX 336981 368366 1 > CSMME32BZX 338754 366842 1 > CSMME07BZX 687965 747694 1 > CSMME03BHW 703269 747623 1 > CSMME12BZX 705856 764656 1 > CSMME16BHW 1962293142173 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 1962293142173 0 -- Best regards, Shaofeng Shi