[jira] [Created] (HIVE-15106) Hive 1.0 returning only date part of a timestamp

["Hernan Vivani (JIRA)" <ji...@apache.org>]

Hernan Vivani created HIVE-15106:
------------------------------------

             Summary: 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)