hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (Jira)" <j...@apache.org>
Subject [jira] [Work logged] (HIVE-25299) Casting timestamp to numeric data types is incorrect for non-UTC timezones
Date Tue, 06 Jul 2021 18:38:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-25299?focusedWorklogId=619544&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-619544
]

ASF GitHub Bot logged work on HIVE-25299:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 06/Jul/21 18:37
            Start Date: 06/Jul/21 18:37
    Worklog Time Spent: 10m 
      Work Description: sankarh commented on pull request #2447:
URL: https://github.com/apache/hive/pull/2447#issuecomment-874992670


   @adesh-rao Could you pls add unit tests?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 619544)
    Time Spent: 40m  (was: 0.5h)

> Casting timestamp to numeric data types is incorrect for non-UTC timezones
> --------------------------------------------------------------------------
>
>                 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
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> *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 (VM timezone is set to 'Asia/Bangkok').



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message