drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-834) The sum() operator should automatically promote to a type that can hold the sum
Date Wed, 28 May 2014 23:30:02 GMT

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

Mime
View raw message