You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2015/04/27 23:30:38 UTC

[jira] [Assigned] (DRILL-2870) Fix return type of aggregate functions to be nullable

     [ https://issues.apache.org/jira/browse/DRILL-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mehant Baid reassigned DRILL-2870:
----------------------------------

    Assignee: Mehant Baid  (was: Aman Sinha)

> Fix return type of aggregate functions to be nullable
> -----------------------------------------------------
>
>                 Key: DRILL-2870
>                 URL: https://issues.apache.org/jira/browse/DRILL-2870
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: Mehant Baid
>            Priority: Critical
>             Fix For: 1.0.0
>
>         Attachments: DRILL-2870.patch
>
>
> The output type of aggregate functions is required if the input is required which does not always hold true. Consider the case where input is a required type and we are performing sum(), however if all the rows are filtered out then we should return null instead of 0. This holds true for all aggregate functions (except count). 
> As part of DRILL-2277 we are fixing the case when we have an aggregate function (without group by) and the input batch is empty we still need to produce one record with null as output (count function is an exception to this). If we don't fix the return type of aggregate functions then we will return wrong results in the case where we have an empty input with required columns. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)