hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinna Rao Lalam (JIRA)" <>
Subject [jira] [Commented] (HIVE-14582) Add trunc(numeric) udf
Date Thu, 22 Sep 2016 12:05:20 GMT


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:
>             Project: Hive
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Ashutosh Chauhan
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-14582.patch

This message was sent by Atlassian JIRA

View raw message