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.

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.

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

Reply via email to