[jira] [Created] (HIVE-6039) Round, AVG and SUM functions reject char/varch input while accepting string input

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

Xuefu Zhang created HIVE-6039:
---------------------------------

             Summary: Round, AVG and SUM functions reject char/varch input while accepting string input
                 Key: HIVE-6039
                 URL: https://issues.apache.org/jira/browse/HIVE-6039
             Project: Hive
          Issue Type: Bug
          Components: UDF
            Reporter: Xuefu Zhang
            Assignee: Xuefu Zhang
             Fix For: 0.13.0


An error similar to the following will occur:
{code}
hive> create table tabs (c char(8), vc varchar(10)) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
hive> select sum(c), avg(c), sum(vc), avg(vc) from tabs;
FAILED: UDFArgumentTypeException Only numeric or string type arguments are accepted but char(8) is passed.
{code}



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)