[HIVE-5472] support a simple scalar which returns the current timestamp

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 1.2.0
• Assignee: Jason Dere
• Reporter: N Campbell
• Created: 06/Oct/13 18:05
• Updated: 28/Oct/17 03:12
• Resolved: 02/Feb/15 19:19

Description

ISO-SQL has two forms of functions

local and current timestamp where the former is a TIMESTAMP WITHOUT TIMEZONE and the latter with TIME ZONE

select cast ( unix_timestamp() as timestamp ) from T

implement a function which computes LOCAL TIMESTAMP which would be the current timestamp for the users session time zone.

Issue Links

• is related to: HIVE-11127 Document time zone handling for current_date and current_timestamp
• relates to: HIVE-9630 partition filter using date_sub result produces non-optimal plans
• links to: https://reviews.apache.org/r/29900/