hongbin ma created KYLIN-1690: --------------------------------- Summary: 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)