hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raghotham Murthy (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-313) add UDF date_add, date_sub, datediff
Date Thu, 12 Mar 2009 06:08:50 GMT

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

Raghotham Murthy commented on HIVE-313:
---------------------------------------

Couple things.

1. What's the locale you would be using for parsing the date? I'm guessing PST? How would
you handle the case where data for a day when there was no daylight savings is queried on
a day when there is daylight savings?

2. In the test query, can you change one of the functions to take as input a column from a
table rather than all tests being constants? This is just to be sure that there is no weirdness
when processing constants vs columns.

3. Do you need the calendar variable in UDFDateDiff?

> add UDF date_add, date_sub, datediff
> ------------------------------------
>
>                 Key: HIVE-313
>                 URL: https://issues.apache.org/jira/browse/HIVE-313
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Zheng Shao
>         Attachments: HIVE-313.1.patch
>
>
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-sub
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff

-- 
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