Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: document timestamp supported text format

...

Timestamps are interpreted to be timezoneless and stored as an offset from the UNIX epoch. Convenience UDFs for conversion to and from timezones are provided (to_utc_timestamp, from_utc_timestamp).
All existing datetime UDFs (month, day, year, hour, etc.) work with the TIMESTAMP data type.

Timestamp in text format files have to comply with format yyyy-mm-dd hh:mm:ss.f.... If they are in another format declare them as an INT, FLOAT or STRING type if they are in the format conversion format listed above, and cast them.

Info
titleVersion

Timestamps were introduced in Hive 0.8.0 (HIVE-2272).

...