You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Adesh Kumar Rao (Jira)" <ji...@apache.org> on 2021/06/30 06:51:00 UTC
[jira] [Created] (HIVE-25299) Casting timestamp to numeric data
types is incorrect
Adesh Kumar Rao created HIVE-25299:
--------------------------------------
Summary: 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
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)