You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Adesh Kumar Rao (Jira)" <ji...@apache.org> on 2021/06/30 06:51:00 UTC
[jira] [Assigned] (HIVE-25299) Casting timestamp to numeric data
types is incorrect
[ https://issues.apache.org/jira/browse/HIVE-25299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adesh Kumar Rao reassigned HIVE-25299:
--------------------------------------
> Casting timestamp to numeric data types is incorrect
> ----------------------------------------------------
>
> Key: HIVE-25299
> URL: https://issues.apache.org/jira/browse/HIVE-25299
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 3.1.2, 4.0.0
> Reporter: Adesh Kumar Rao
> Assignee: Adesh Kumar Rao
> Priority: Major
> Fix For: 4.0.0
>
>
> *Hive 1.2.1*
> {noformat}
> Connected to: Apache Hive (version 1.2.1000.2.6.5.3033-1)
> Driver: Hive JDBC (version 1.2.1000.2.6.5.3033-1)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 1.2.1000.2.6.5.3033-1 by Apache Hive
> 0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as int);
> +-------------+--+
> | _c0 |
> +-------------+--+
> | 1615658400 |
> +-------------+--+
> 1 row selected (0.387 seconds)
> 0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as bigint);
> +-------------+--+
> | _c0 |
> +-------------+--+
> | 1615658400 |
> +-------------+--+
> 1 row selected (0.369 seconds)
> 0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as double);
> +--------------+--+
> | _c0 |
> +--------------+--+
> | 1.6156584E9 |
> +--------------+--+
> {noformat}
> *Hive 3.1, 4.0*
> {noformat}
> Connected to: Apache Hive (version 3.1.0.3.1.6.1-6)
> Driver: Hive JDBC (version 3.1.4.4.1.4.8)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 3.1.4.4.1.4.8 by Apache Hive
> 0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as int);
> +-------------+
> | _c0 |
> +-------------+
> | 1615683600 |
> +-------------+
> 1 row selected (0.666 seconds)
> 0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as bigint);
> +-------------+
> | _c0 |
> +-------------+
> | 1615683600 |
> +-------------+
> 1 row selected (0.536 seconds)
> 0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14 01:00:00" as timestamp) as double);
> +--------------+
> | _c0 |
> +--------------+
> | 1.6156836E9 |
> +--------------+
> 1 row selected (0.696 seconds)
> {noformat}
>
> The issue occurs for non-UTC timezone.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)