陈雷雷 created KYLIN-1630: -------------------------- Summary: 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 Reporter: 陈雷雷
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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)