hive-issues mailing list archives

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

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

Mime
View raw message