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

["Dong Li (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284046#comment-15284046 ] 

Dong Li edited comment on KYLIN-1690 at 5/16/16 1:13 AM:
---------------------------------------------------------

This is a duplicated JIRA KYLIN-1630, which is resolved with workaround.
Link them for tracking.


was (Author: lidong_sjtu):
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)