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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: UDF
• Assignee: Xuefu Zhang
• Reporter: Xuefu Zhang
• Created: 16/Dec/13 22:00
• Updated: 20/Dec/13 18:29
• Resolved: 20/Dec/13 18:29

Description

An error similar to the following will occur:

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.

Issue Links

• links to: https://reviews.apache.org/r/16329/