Re: negative result in kylin 2.3.0

Hi The definition is bigInt and it seems that this type can not be modified. In our Cube, we have a date type dimension with year, month, dayofmonth hierarchy, we query the sum measure using year group, the result is negative but using month group the result is correct and sum the

Re: negative result in kylin 2.3.0

Hi ZhangXuan, Could you share the return type definition on your SUM measure? And also some test cases are welcomed. With Warm regards Billy Liu 2018-03-16 22:49 GMT-07:00 ZhangXuan : > Hi >Successfully built a Cube with 4 billion data on kylin upgraded from > 2.2.0 to

negative result in kylin 2.3.0

Hi   Successfully built a Cube with 4 billion data on kylin upgraded from 2.2.0 to 2.3.0, When I use SQL query the data according to a large dimension, a  negative sum measure number appears in the result, but when using a relatively  small dimension, the data is correct. However, this did not