[
https://issues.apache.org/jira/browse/DRILL-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-2870.
-----------------------------------
Resolution: Fixed
Resolved in e0070e2
> 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
> Components: Execution - Data Types
> Reporter: Mehant Baid
> Assignee: Mehant Baid
> Priority: Critical
> Fix For: 1.0.0
>
>
> 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)
