[
https://issues.apache.org/jira/browse/HIVE-18863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16386551#comment-16386551
]
Vihang Karajgaonkar commented on HIVE-18863:
--------------------------------------------
Can you please clarify what is the bug here? Based on the error message it
looks like trunc UDF accepts string/char/varchar as the second argument, but in
this case it got a timestamp.
> trunc() calls itself trunk() in an error message
> ------------------------------------------------
>
> Key: HIVE-18863
> URL: https://issues.apache.org/jira/browse/HIVE-18863
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Reporter: Tim Armstrong
> Priority: Minor
> Labels: newbie
>
> {noformat}
> > 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
> {noformat}
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
