Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2557

Inserting illegal timestamp behaves differently that in MySql

    Details

    • Type: Bug
    • Status: Open
    • Priority: 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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: