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