[
https://issues.apache.org/jira/browse/KYLIN-2513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15960210#comment-15960210
]
liyang commented on KYLIN-2513:
-------------------------------
Merged into master.
> SUM measure return type should not overflow
> -------------------------------------------
>
> Key: KYLIN-2513
> URL: https://issues.apache.org/jira/browse/KYLIN-2513
> Project: Kylin
> Issue Type: Bug
> Components: Metadata
> Affects Versions: v1.6.0
> Reporter: Billy Liu
> Assignee: hongbin ma
> Attachments:
> 0001-KYLIN-2513-SUM-measure-return-type-should-not-overfl.patch
>
>
> Currently, the SUM measure return type is the same with original table column
> type, that would not work if the original table column has very limit digit
> capability. Take an example, the original column type is decimal(1,0), if we
> SUM on this column, the result will be overflow soon.
> Proposal: Define the return type much more clear. If the original column type
> is decimal with decimal point, no matter what the precision digit is, define
> the return type as decimal(19,4). If the original column type has no decimal
> point，define the return type as decimal(14,0). If the original column is
> integer family, the return type would be bigint.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
