You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Vladimir Prus (JIRA)" <ji...@apache.org> on 2018/01/29 10:34:00 UTC

[jira] [Created] (PHOENIX-4564) AVG function always returns BigDecimal

Vladimir Prus created PHOENIX-4564:
--------------------------------------

             Summary: AVG function always returns BigDecimal
                 Key: PHOENIX-4564
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4564
             Project: Phoenix
          Issue Type: Bug
            Reporter: Vladimir Prus


Per documentation for 'AVG' function:

The average (mean) value. If no rows are selected, the result is {{NULL}}. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.

However, the code at

[https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/expression/function/AvgAggregateFunction.java]

actually returns BigDecimal, no matter what. That is inconsistent with documentation, and user expectations, and I'm not sure what benefits it brings. Say, in Hive 'avg' does return the same type as the expression, and it works fine. 



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