Hive
  1. Hive
  2. HIVE-2557

Inserting illegal timestamp behaves differently that in MySql

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Trivial Trivial
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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.

        Activity

        Robert Surówka created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Robert Surówka
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development