[jira] [Created] (DRILL-6221) Decimal aggregations for NULL values result in 0.0 value

[Andries Engelbrecht (JIRA)]

Andries Engelbrecht created DRILL-6221:
------------------------------------------

             Summary: 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


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)