[HIVE-21349] TIMESTAMP WITHOUT TIME ZONE

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Zoltan Ivanfi
• Created: 28/Feb/19 15:49
• Updated: 02/Aug/19 09:16

Description

As specified in the design doc for TIMESTAMP types, the TIMESTAMP WITHOUT TIME ZONE type shall behave like the LocalDateTime class of Java, i.e., each value is a recording of what can be seen on a calendar and a clock hanging on the wall, for example "1969-07-20 16:17:39". It can be decomposed into year, month, day, hour, minute and seconds fields, but with no time zone information available, it does not correspond to any specific point in time.

This behaviour is consistent with the SQL standard (revisions 2003 and higher).

Issue Links

• is a child of: HIVE-21348 Execute the TIMESTAMP types roadmap
• is a parent of: HIVE-21359 Parquet support for TIMESTAMP WITHOUT TIME ZONE
• is a parent of: HIVE-21360 Avro support for TIMESTAMP WITHOUT TIME ZONE
• is a parent of: HIVE-21361 ORC support for TIMESTAMP WITHOUT TIME ZONE