[HIVE-25458] unix_timestamp() with string input give wrong result

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: UDF
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Ashish Sharma
• Reporter: Ashish Sharma
• Created: 17/Aug/21 11:20
• Updated: 21/Aug/23 10:00
• Resolved: 21/Aug/21 15:13

Description

Description -

unix_timestamp() accept 4 value string/date/timestamp/timestamptz. Out of which date/timestamp/timestamptz use DateTimeFormatter.class where as string type use SimpleDateTimeformatter.class which cause difference is value.

Example -
select from_unixtime(unix_timestamp('1800-11-08 01:53:11'));
1800-11-08 01:35:15

select from_unixtime(unix_timestamp(cast('1800-11-08 01:53:11' as timestamp)));
1800-11-08 01:53:11

Issue Links

• causes: HIVE-25577 unix_timestamp() is ignoring the time zone value
• is duplicated by: HIVE-25499 select unix_timestamp(dt) from table and select unix_timestamp(constant date) are different
• is related to: HIVE-25576 Configurable datetime formatter for unix_timestamp, from_unixtime
• links to: GitHub Pull Request #2590