[HIVE-22170] from_unixtime and unix_timestamp should use user session time zone

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 3.1.1, 3.1.2, 3.2.0, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Labels: datetime pull-request-available timestamp
• Assignee: Jesús Camacho Rodríguez
• Reporter: Riju Trivedi
• Created: 05/Sep/19 01:32
• Updated: 27/Feb/24 22:23
• Resolved: 17/Sep/19 18:45

Description

According to documentation, that is the expected behavior (since session time zone was not present, system time zone was being used previously). This was incorrectly changed by HIVE-12192 / HIVE-20007. This JIRA should fix this issue.

Issue Links

• causes: HIVE-22331 unix_timestamp without argument returns timestamp in millisecond instead of second.
• Is contained by: HIVE-26751 Bug Fixes and Improvements for 3.2.0 release
• links to: GitHub Pull Request #764