[
https://issues.apache.org/jira/browse/HIVE-18863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vihang Karajgaonkar updated HIVE-18863:
---------------------------------------
Resolution: Fixed
Fix Version/s: 2.4.0
3.0.0
Status: Resolved (was: Patch Available)
Patch merged in master and branch-2. Thanks for your contribution [~bharos92]
> 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
> Assignee: Bharathkrishna Guruvayoor Murali
> Priority: Minor
> Labels: newbie
> Fix For: 3.0.0, 2.4.0
>
> Attachments: HIVE-18863.1.patch, HIVE-18863.2.patch
>
>
> {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)
