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)

Reply via email to