[HIVE-1269] Support Date/Datetime/Time/Timestamp Primitive Types

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Tags: date time datetime timestamp
• Assignee: Unassigned
• Reporter: Carl Steinbach
• Created: 23/Mar/10 05:13
• Updated: 09/Aug/23 10:11

Description

Add support for SQL Date, DateTime, Time and TimeStamp primitive types.

Issue Links

• incorporates: HIVE-4055 add Date data type
• incorporates: HIVE-27587 Add TIME data type
• incorporates: HIVE-2272 add TIMESTAMP data type
• is related to: HIVE-814 exception alter a int typed column to date/datetime/timestamp
• is related to: HIVE-1059 Date/DateTime/TimeStamp types should throw an error
• is related to: PIG-1314 Add DateTime Support to Pig
• is related to: HIVE-192 DUPLICATE: Add TIMESTAMP column type for thrift dynamic_type
• is related to: HIVE-345 Extend Date UDFs to support time zone and full specs as in MySQL
• is related to: HIVE-2974 Add online docs for from_utc_timestamp() and to_utc_timestamp()
• is required by: HIVE-1386 HiveQL SQL Compliance (Umbrella)