You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Paul Yang (JIRA)" <ji...@apache.org> on 2009/11/04 01:21:32 UTC
[jira] Created: (HIVE-911) Add weekofyear UDF
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
Provide a way for users to get week number for a date, similar to the function weekofyear() in MySQL.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-911) Add weekofyear UDF
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12773753#action_12773753 ]
Zheng Shao commented on HIVE-911:
---------------------------------
+1. Will test and commit.
> 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
> 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.
[jira] Updated: (HIVE-911) Add weekofyear UDF
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Yang updated HIVE-911:
---------------------------
Attachment: weekofyear.3.patch
> 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
> 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.
[jira] Updated: (HIVE-911) Add weekofyear UDF
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Yang updated HIVE-911:
---------------------------
Description: Provide a way for users to get the week number for a date, similar to weekofyear() in MySQL. (was: Provide a way for users to get week number for a date, similar to the function weekofyear() in MySQL.)
> 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
>
> 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.
[jira] Resolved: (HIVE-911) Add weekofyear UDF
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao resolved HIVE-911.
-----------------------------
Resolution: Fixed
Fix Version/s: 0.5.0
Release Note: HIVE-911. Add UDF WeekOfYear. (Paul Yang via zshao)
Committed. Thanks Paul!
> 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.
[jira] Commented: (HIVE-911) Add weekofyear UDF
Posted by "Luis Ramos (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HIVE-911) Add weekofyear UDF
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12788377#action_12788377 ]
Paul Yang commented on HIVE-911:
--------------------------------
Well, it does follow the mysql standard for weekofyear(), though I agree implementing week() is probably a better idea.
> 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.