You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by ZhangXuan <zh...@czkj1010.com> on 2018/03/17 05:49:51 UTC
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 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.
Re: negative result in kylin 2.3.0
Posted by ZhangXuan <zh...@czkj1010.com>.
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 <bi...@apache.org> 写道：
>
> 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 <zh...@czkj1010.com>:
>> 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.
Re: negative result in kylin 2.3.0
Posted by Billy Liu <bi...@apache.org>.
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 <zh...@czkj1010.com>:
> 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.