[IMPALA-8068] A day may belong to a different year than the week it is a part of

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.1.0
• Component/s: Backend
• Labels: correctness
• Epic Color: ghx-label-9
• Assignee: Unassigned
• Reporter: Zoltan Ivanfi
• Created: 11/Jan/19 14:55
• Updated: 22/Dec/20 21:05

Description

When using the year() and weekofyear() functions in a query, their result is 2018 and 1 (respectively) for the day '2018-12-31'.

The year() function returns 2018 for the input '2018-12-31', because that day belongs to the year 2018.

The weekofyear() functions returns 1 for the input '2018-12-31', because that day belongs to the first week of 2019.

Both functions provide sensible results on their own, but when combined, the result is wrong, because '2018-12-31' does not belong to week 1 of 2018.

I suggest adding a new function yearofweek() that would return 2019 for the input '2018-12-31' and adding a warning to the documentation of the weekofyear() function about this problem.

Issue Links

• is related to: HIVE-21117 A day may belong to a different year than the week it is a part of