Naresh P R created HIVE-20599: --------------------------------- Summary: 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 Fix For: 3.1.0
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)