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

          People

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

            Dates

            • Created:
              Updated:

              Development