hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zachary Tyler Pruitt (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14653) week value is different between weekofyear(date) and date_format(date, "ww")
Date Mon, 11 Dec 2017 21:09:00 GMT

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

Zachary Tyler Pruitt commented on HIVE-14653:
---------------------------------------------

ISO 8601 specifies that the first day of the week is Monday.
ISO 8601 specifies that the first week of the year will be the week with the first Thursday
in it.

WEEKOFYEAR is following ISO 8601.
DATE_FORMAT is not.

{code}
SELECT Calendar_Date,
    DATE_FORMAT(Calendar_Date, 'EEEE') AS Day_Of_Week,
    DATE_FORMAT(Calendar_Date, 'u') AS Day_Of_Week,
    WEEKOFYEAR(Calendar_Date) AS Week_Of_Year_wof,
    DATE_FORMAT(Calendar_Date, 'w') AS Week_Of_Year_df,
    DATE_FORMAT(Calendar_Date, 'W') AS Week_Of_Month
FROM (SELECT EXPLODE(ARRAY('2016-12-31','2017-01-01','2017-01-02')) AS Calendar_Date) c;

+----------------+--------------+--------------+-------------------+------------------+----------------+--+
| calendar_date  | day_of_week  | day_of_week  | week_of_year_wof  | week_of_year_df  | week_of_month
 |
+----------------+--------------+--------------+-------------------+------------------+----------------+--+
| 2016-12-31     | Saturday     | 6            | 52                | 53               | 5
             |
| 2017-01-01     | Sunday       | 7            | 52                | 1                | 1
             |
| 2017-01-02     | Monday       | 1            | 1                 | 1                | 1
             |
+----------------+--------------+--------------+-------------------+------------------+----------------+--+
{code}

> week value is different between weekofyear(date) and date_format(date, "ww")
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-14653
>                 URL: https://issues.apache.org/jira/browse/HIVE-14653
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Shawn Zhou
>            Priority: Minor
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message