Inserting illegal timestamp behaves differently that in MySql
-------------------------------------------------------------
Key: HIVE-2557
URL: https://issues.apache.org/jira/browse/HIVE-2557
Project: Hive
Issue Type: Bug
Reporter: Robert Surówka
Priority: Trivial
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
