[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625937#comment-16625937 ]
Hive QA commented on HIVE-20599: -------------------------------- | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 52s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 1m 28s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14018/dev-support/hive-personality.sh | | git revision | master / a51e6ae | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14018/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-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch, HIVE-20599.3.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)