You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2008/12/04 20:44:44 UTC
[jira] Created: (HIVE-118) Add date related functions to Hive
Add date related functions to Hive
----------------------------------
Key: HIVE-118
URL: https://issues.apache.org/jira/browse/HIVE-118
Project: Hadoop Hive
Issue Type: New Feature
Reporter: Zheng Shao
Assignee: Zheng Shao
Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-118) Add date related functions to Hive
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-118:
--------------------------------
Fix Version/s: 0.3.0
Component/s: UDF
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Fix For: 0.3.0
>
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654606#action_12654606 ]
Zheng Shao commented on HIVE-118:
---------------------------------
We should have that but unfortunately the current code may recognize "date" as a predefined keyword. We might be able to specify `date`(xxx) where ` is the back quote on the left to "1" on the keyboard.
If you could try it out and add it if it works that will be great.
Also we do have the "to_date" function which probably does what you want. The name of "to_date" comes from oracle. But supporting what mysql does is our goal.
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao updated HIVE-118:
----------------------------
Status: Patch Available (was: Open)
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12653438#action_12653438 ]
Ashish Thusoo commented on HIVE-118:
------------------------------------
+1
Looks good to me.
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "Raghotham Murthy (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12653439#action_12653439 ]
Raghotham Murthy commented on HIVE-118:
---------------------------------------
+1
looks good.
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "David Phillips (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654587#action_12654587 ]
David Phillips commented on HIVE-118:
-------------------------------------
Minor bug, this registers the wrong class:
registerUDF("day", UDFDayOfMonth.class, OperatorType.PREFIX, false);
We need tests that validate these functions. I'll work on that.
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao updated HIVE-118:
----------------------------
Resolution: Fixed
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
HIVE-118. Add date related functions. (zshao)
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "David Phillips (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654603#action_12654603 ]
David Phillips commented on HIVE-118:
-------------------------------------
Sorry, I confused "day" with "date". Should we have a date function?
registerUDF("date", UDFDate.class, OperatorType.PREFIX, false);
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao updated HIVE-118:
----------------------------
Attachment: HIVE-118-1.patch
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654590#action_12654590 ]
Zheng Shao commented on HIVE-118:
---------------------------------
Thanks for finding this out.
We probably want to make both "day" and "dayofmonth" available to our users as synonyms, according to http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-118) Add date related functions to Hive
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12653447#action_12653447 ]
Zheng Shao commented on HIVE-118:
---------------------------------
Committed. svn revision: 723419
> Add date related functions to Hive
> ----------------------------------
>
> Key: HIVE-118
> URL: https://issues.apache.org/jira/browse/HIVE-118
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-118-1.patch
>
>
> Add FromUnixTime, Year, Month, DayOfMonth, and Date functions as in mysql: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.