[HIVE-18863] trunc() calls itself trunk() in an error message

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.4.0, 3.0.0
• Component/s: UDF
• Labels: newbie
• Assignee: Bharath Krishna
• Reporter: Tim Armstrong
• Created: 05/Mar/18 18:38
• Updated: 22/May/18 23:15
• Resolved: 23/Mar/18 23:59

Description

> select  trunc('millennium', cast('2001-02-16 20:38:40' as timestamp))
FAILED: SemanticException Line 0:-1 Argument type mismatch ''2001-02-16 20:38:40'': trunk() only takes STRING/CHAR/VARCHAR types as second argument, got TIMESTAMP

I saw this on a derivative of Hive 1.1.0 (cdh5.15.0), but the string still seems to be present on master:
https://github.com/apache/hive/blob/6d890faf22fd1ede3658a5eed097476eab3c67e9/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFTrunc.java#L262