hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Pathak (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-21081) DATE_FORMAT incorrectly returns results on the last week of the calendar year
Date Tue, 12 Feb 2019 04:43:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-21081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16765672#comment-16765672
] 

Rahul Pathak commented on HIVE-21081:
-------------------------------------

This looks like expected behavior.

Y represent week year and y is used to represent calendar year. 

A week year is in sync with a WEEK_OF_YEAR cycle. 

All weeks between the first and last weeks (inclusive) have the same week year value. 

Therefore, the first and last days of a week year may have different calendar year values.


https://docs.oracle.com/javase/9/docs/api/java/util/GregorianCalendar.html#week_year 

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF 


> DATE_FORMAT incorrectly returns results on the last week of the calendar year
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-21081
>                 URL: https://issues.apache.org/jira/browse/HIVE-21081
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.1.1, 2.3.2, 2.3.3
>            Reporter: Wilson Lu
>            Priority: Minor
>
> The Hive DATE_FORMAT does not perform the correct operation on the last week of the calendar
year. The following statements incorrectly formats the data:
> select DATE_FORMAT('2017-12-31', 'YYYYMM')
> select DATE_FORMAT('2018-12-30', 'YYYYMM')
>  select DATE_FORMAT('2018-12-31', 'YYYYMM')
> select DATE_FORMAT('2019-12-29', 'YYYYMM')
>  select DATE_FORMAT('2019-12-30', 'YYYYMM')
>  select DATE_FORMAT('2019-12-31', 'YYYYMM')
> select DATE_FORMAT( '2019-12-29', 'YYYYMMdd') 
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message