Zoltan Ivanfi created HIVE-21117:
------------------------------------
Summary: A day may belong to a different year than the week it is
a part of
Key: HIVE-21117
URL: https://issues.apache.org/jira/browse/HIVE-21117
Project: Hive
Issue Type: New Feature
Affects Versions: 2.3.4
Reporter: Zoltan Ivanfi
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() and adding a warning to the
documentation of the weekofyear() function about this problem.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
