Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.2.1, 2.1.0, 3.0.0, 3.1.1
-
None
-
None
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