[ https://issues.apache.org/jira/browse/KYLIN-1690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284046#comment-15284046 ]
Dong Li commented on KYLIN-1690: -------------------------------- This is a duplicated JIRA, which is resolved with workaround. Link them for tracking. > always returning 0 or 1 for sum(a)/sum(b) for integer type a and b > ------------------------------------------------------------------ > > Key: KYLIN-1690 > URL: https://issues.apache.org/jira/browse/KYLIN-1690 > Project: Kylin > Issue Type: Bug > Reporter: hongbin ma > Assignee: hongbin ma > > 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)