[
https://issues.apache.org/jira/browse/HIVE-14582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15513101#comment-15513101
]
Chinna Rao Lalam commented on HIVE-14582:
-----------------------------------------
Hi [~niklaus.xiao]. In hive already one function is there with the name
*trunc* related to date function.
{quote}
trunc(string date, string format)
Returns date truncated to the unit specified by the format (as of Hive 1.2.0).
Supported formats: MONTH/MON/MM, YEAR/YYYY/YY. Example: trunc('2015-03-17',
'MM') = 2015-03-01.
{quote}
I am checking which is better like renaming the existing one or this function,
like *truncnumber* something like this. I need to add some more tests and some
improvements. I will update along with this.
Renaming existing function name effect backward compatibility. Any suggestions.
> Add trunc(numeric) udf
> ----------------------
>
> Key: HIVE-14582
> URL: https://issues.apache.org/jira/browse/HIVE-14582
> Project: Hive
> Issue Type: Sub-task
> Components: SQL
> Reporter: Ashutosh Chauhan
> Assignee: Chinna Rao Lalam
> Attachments: HIVE-14582.patch
>
>
> https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
