[HIVE-25403] Fix from_unixtime() to consider leap seconds

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 3.1.1, 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive
• Labels: UDF pull-request-available
• Assignee: Sruthi Mooriyathvariam
• Reporter: Sruthi Mooriyathvariam
• Created: 29/Jul/21 09:13
• Updated: 21/Aug/23 10:00
• Resolved: 11/Aug/21 05:58

Description

The Unix_timestamp() considers "leap second" while the from_unixtime is not; which results in to wrong result as below:

Issue Links

• causes: HIVE-26290 Remove useless calls to DateTimeFormatter#withZone without assignment
• is related to: HIVE-25576 Configurable datetime formatter for unix_timestamp, from_unixtime
• links to: GitHub Pull Request #2550