[HIVE-7279] UDF format_number() does not work on DECIMAL types

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.14.0
• Component/s: UDF
• Assignee: Wilbur Yang
• Reporter: Szehon Ho
• Created: 24/Jun/14 19:01
• Updated: 15/Nov/14 00:57
• Resolved: 12/Jul/14 22:10

Description

I believe UDF format should work on decimal types.

hive> select format_number(decimal_1.u,1) from decimal_1;
FAILED: SemanticException [Error 10016]: Line 1:21 Argument type mismatch 'u': Argument 1 of function FORMAT_NUMBER must be "tinyint" or "smallint" or "int" or "bigint" or "double" or "float", but "decimal(5,0)" was found.