[
https://issues.apache.org/jira/browse/HIVE-2019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13634112#comment-13634112
]
Zhuoluo (Clark) Yang commented on HIVE-2019:
--------------------------------------------
If we use now() for filters, the result will be uncertain.
Because if a Map Task is scheduled first, the now() of this map task is
earlier, if this task is scheduled later, the now() of this map task is later.
In our production environment, a lot of hive tasks are scheduled at mid night,
the now() of the Tasks may cross a day for the scheduling orders.
I think it is necessary to add a kind of UDF called UDCF. (User Defined Client
Functions). if we get the client side now() and make it a constant during
compile time, it will be no such problems.
> Implement NOW() UDF
> -------------------
>
> Key: HIVE-2019
> URL: https://issues.apache.org/jira/browse/HIVE-2019
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Carl Steinbach
> Assignee: Priyadarshini
> Attachments: HIVE-2019.patch
>
>
> Reference:
> http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
