hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luis Ramos (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-911) Add weekofyear UDF
Date Wed, 09 Dec 2009 20:02:18 GMT

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

Luis Ramos commented on HIVE-911:
---------------------------------

Works, but not ISO standard. If you don't mind the week starting on Monday then it works.
I think we could update this to follow MySQL with the options of modes. At least we can update
it to allow the user to select from Monday or Sunday as the starting day of the week.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_week

Thanks.

> Add weekofyear UDF
> ------------------
>
>                 Key: HIVE-911
>                 URL: https://issues.apache.org/jira/browse/HIVE-911
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Paul Yang
>            Assignee: Paul Yang
>             Fix For: 0.5.0
>
>         Attachments: weekofyear.3.patch
>
>
> Provide a way for users to get the week number for a date, similar to weekofyear() in
MySQL.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message