drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Volodymyr Vysotskyi (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-6221) Decimal aggregations for NULL values result in 0.0 value
Date Mon, 07 May 2018 07:03:00 GMT

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

Volodymyr Vysotskyi resolved DRILL-6221.
----------------------------------------
    Resolution: Fixed

Fixed in the scope of DRILL-6094

> Decimal aggregations for NULL values result in 0.0 value
> --------------------------------------------------------
>
>                 Key: DRILL-6221
>                 URL: https://issues.apache.org/jira/browse/DRILL-6221
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types
>    Affects Versions: 1.12.0
>            Reporter: Andries Engelbrecht
>            Assignee: Volodymyr Vysotskyi
>            Priority: Minor
>
> If you sum a packed decimal field with a null value instead of null you get 0.0.
>  
> select id, amt from hive.`default`.`packtest`
> 1 2.3
> 2 null
> 3 4.5
>  
> select sum(amt) from hive.`default`.`packtest` group by id
> 1 2.3
> 2 0.0
> 3 4.5



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message