[jira] [Created] (KYLIN-1690) always returning 0 or 1 for sum(a)/sum(b) for integer type a and b

["hongbin ma (JIRA)" <ji...@apache.org>]

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)