[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623560#comment-16623560 ]
Hive QA commented on HIVE-20599: -------------------------------- | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:red}-1{color} | {color:red} patch {color} | {color:red} 0m 10s{color} | {color:red} /data/hiveptest/logs/PreCommit-HIVE-Build-13951/patches/PreCommit-HIVE-Build-13951.patch does not apply to master. Rebase required? Wrong Branch? See http://cwiki.apache.org/confluence/display/Hive/HowToContribute for help. {color} | \\ \\ || Subsystem || Report/Notes || | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-13951/yetus.txt | | Powered by | Apache Yetus http://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --------------------------------------------------------------- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF > Affects Versions: 3.1.0 > Reporter: Naresh P R > Assignee: Naresh P R > Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=40000){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)