Affects Version/s: None
Fix Version/s: None
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;
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.