[HIVE-22099] Several date related UDFs can't handle Julian dates properly since HIVE-20007

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Ádám Szita
• Reporter: Ádám Szita
• Created: 12/Aug/19 09:21
• Updated: 27/Feb/24 22:24
• Resolved: 07/Sep/19 07:12

Description

Currently dates that belong to Julian calendar (before Oct 15, 1582) are handled improperly by date/timestamp UDFs.

E.g. DateFormat UDF:

Although the dates are in Julian calendar, the formatter insists to print these according to Gregorian calendar causing multiple days of difference in some cases:

 

beeline> select date_format('1001-01-05','dd---MM--yyyy');
+----------------+
| _c0 |
+----------------+
| 30---12--1000 |
+----------------+

 I've observed similar problems in the following UDFs:

• add_months
• date_format
• day
• month
• months_between
• weekofyear
• year