[HIVE-21121] Cast date to timestamp incorrect interpretation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.1, 2.1.0, 3.0.0, 3.1.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: paco87
• Due: 14/Jan/19
• Created: 14/Jan/19 13:33
• Updated: 06/Feb/19 15:22

Description

Hive is returning timestamp with current time when casting date to timestamp, where it should be 00:00:00.0 .

This issue is wired. It seems that this happens only on specific dates: '1900-01-01'.

----------------------------+

ab

----------------------------+

1900-01-01 11:28:46.869

1900-01-01 11:28:46.869

1900-01-01 11:28:46.869

1900-01-01 11:28:46.869

1890-01-01 00:00:00.0

1901-01-01 00:00:00.0

1900-01-01 11:28:46.869

---------------------------+

I didin't notice this on any other date.

 This might be connected to old issue: HIVE-10488