[jira] [Created] (HIVE-6459) Change the precison/scale for intermediate sum result in the avg() udf

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

Xuefu Zhang created HIVE-6459:
---------------------------------

             Summary: Change the precison/scale for intermediate sum result in the avg() udf 
                 Key: HIVE-6459
                 URL: https://issues.apache.org/jira/browse/HIVE-6459
             Project: Hive
          Issue Type: Improvement
          Components: UDF
    Affects Versions: 0.13.0
            Reporter: Xuefu Zhang
            Assignee: Xuefu Zhang


The avg() udf, when applied to a decimal column, selects the precision/scale of the intermediate sum field as (p+4, s+4), which is the same for the precision/scale of the avg() result. However, the additional scale increase is unnecessary, and the problem of data overflow may occur. The requested change is that for the intermediate sum result,  the precsion/scale is set to (p+10, s), which is consistent to sum() udf. The avg() result still keeps its precision/scale.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)