[HIVE-2557] Inserting illegal timestamp behaves differently that in MySql

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Duplicate
• Assignee: Ashish Sharma
• Reporter: Robert Surówka
• Created: 08/Nov/11 00:27
• Updated: 26/Jul/21 05:07
• Resolved: 26/Jul/21 05:07

Description

In MySql there is:

Illegal DATETIME, DATE, or TIMESTAMP values are converted to the "zero" value of the appropriate type ('0000-00-00 00:00:00' or '0000-00-00'). ( http://dev.mysql.com/doc/refman/5.1/en/datetime.html ), yet in Hive we have e.g.:

hive> insert into table rrt select '1970-01-51 00:00:05' from src_copy limit 1;
hive> select * from rrt;
1970-02-20 00:00:05

It is probably something to be discussed whether to change it, but at least we should be aware of this current inconsistency, especially when documentation for timestamp will be added.

Issue Links

• is related to: HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT