[
https://issues.apache.org/jira/browse/IMPALA-8068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-8068:
----------------------------------
Labels: correctness (was: )
> A day may belong to a different year than the week it is a part of
> ------------------------------------------------------------------
>
> Key: IMPALA-8068
> URL: https://issues.apache.org/jira/browse/IMPALA-8068
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend
> Affects Versions: Impala 3.1.0
> Reporter: Zoltan Ivanfi
> Priority: Major
> Labels: correctness
> Attachments: image-2019-01-11-16-42-41-460.png
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
