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 result it exceed 2
billion.
> 在 2018年3月19日，02:34，Billy Liu <[email protected]> 写道：
>
> 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 <[email protected]>:
>> 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 appear in the previous 2.0.0 version, and the old Cube was built in
>> version 2.0.0 also occurs in 2.3.0. I guess it should be dynamic calculated
>> using int type and overflow.
>> How can I fix this? Thanks.
