[ https://issues.apache.org/jira/browse/HIVE-21121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paco87 updated HIVE-21121: -------------------------- 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 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 was: 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 > Cast date to timestamp 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 should be 00:00:00.0 . > This issue is wired. It seems 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)