[HIVE-15106] Hive 1.0 returning only date part of a timestamp

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0
• Component/s: Hive

Environment

Amazon EMR 4.8

• Assignee: Unassigned
• Reporter: Hernan Vivani
• Created: 01/Nov/16 21:35
• Updated: 04/Nov/16 13:46

Description

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

Issue Links

• relates to: HIVE-12749 Constant propagate returns string values in incorrect format