hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Illya Yalovyy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15106) Hive 1.0 returning only date part of a timestamp
Date Fri, 04 Nov 2016 13:46:58 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15636373#comment-15636373
] 

Illya Yalovyy commented on HIVE-15106:
--------------------------------------

This is a bug in Constant propagation optimizer. It does "unsafe" casting that causes data
corruption in some cases. 
It was fixed for Hive 2.x by patch HIVE-12749. I don't see a patch for Hive 1.x line.

Please keep in mind that there are several very simple workarounds:

1. set hive.optimize.constant.propagation=false;
2. select event_ts from test_order where to_date(event_ts) = to_date('2016-11-07'); 

> Hive 1.0 returning only date part of a timestamp
> ------------------------------------------------
>
>                 Key: HIVE-15106
>                 URL: https://issues.apache.org/jira/browse/HIVE-15106
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.0.0
>         Environment: Amazon EMR 4.8
>            Reporter: Hernan Vivani
>
> Hive 1.0 is returning only the date part of a timestamp.
> This is working properly on Hive 0.13 and Hive 2.1.0
> Reproduction steps:
> In Hive 0.13 and Hive 2.1.0:
> hive> create table test_order as select timestamp('2016-11-07 09:29:59.000000') as
event_ts;
> hive> select * from test_order;
> 2016-11-07 09:29:59
> hive> select event_ts from test_order where CAST(event_ts AS DATE ) = CAST('2016-11-07'
AS DATE );
> 2016-11-07 09:29:59
> But, in Hive 1.0:
> hive> select event_ts from test_order where CAST(event_ts AS DATE ) = CAST('2016-11-07'
AS DATE );
> 2016-11-07 00:00:00



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message