[jira] [Commented] (KYLIN-2513) SUM measure return type should not overflow

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

    [ 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)