Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Wed, 28 May 2014 23:30:02 +0000 (UTC)
From: "Chun Chang (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12716467.1400886724417.35474.1401319802621@arcas>
In-Reply-To: <JIRA.12716467.1400886724417@arcas>
References: <JIRA.12716467.1400886724417@arcas>
Subject: [jira] [Commented] (DRILL-834) The sum() operator should
 automatically promote to a type that can hold the sum
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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