[
https://issues.apache.org/jira/browse/DRILL-834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14011813#comment-14011813
]
Chun Chang commented on DRILL-834:
----------------------------------
We are working with big data. We should anticipate that sum() will overflow the
original type quite often. The correct behavior should be to automatically
promote the type to a bigger type that will give correct result. postgres,
which is not designed for "big data", handles it that way. We definitely should
do the same here.
> The sum() operator should automatically promote to a type that can hold the
> sum
> -------------------------------------------------------------------------------
>
> Key: DRILL-834
> URL: https://issues.apache.org/jira/browse/DRILL-834
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Chun Chang
> Assignee: Chun Chang
> Priority: Blocker
>
> The sum() of a type may exceed the type range, hence, should implicitly and
> automatically promote to a type that can hold the sum. Currently, the sum
> just overflows into negative (see JIRA833) and gives wrong result.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
