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)