[ https://issues.apache.org/jira/browse/HIVE-21121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paco87 updated HIVE-21121: -------------------------- Summary: Cast incorrect interpretation (was: Cast incorrect interpretaton) > Cast incorrect interpretation > ----------------------------- > > Key: HIVE-21121 > URL: https://issues.apache.org/jira/browse/HIVE-21121 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 1.2.1 > Reporter: paco87 > Priority: Major > Attachments: jira_replicate_issue.txt > > > Hive is returning timestamp with current time when casting, date to > timestamp, where it shoudl be 00:00:00.0 . > This issue is wired I found out that this happens only on specific date: > '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 -- This message was sent by Atlassian JIRA (v7.6.3#76005)