You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naresh P R (JIRA)" <ji...@apache.org> on 2018/09/19 16:51:00 UTC
[jira] [Updated] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is
throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naresh P R updated HIVE-20599:
------------------------------
Attachment: HIVE-20599.1-branch-3.1.patch
Status: Patch Available (was: In Progress)
> 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.1-branch-3.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)