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)
