hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15324) Enable round() function to accept scale argument as non-constants
Date Sat, 31 Dec 2016 17:51:58 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15789811#comment-15789811
] 

Xuefu Zhang commented on HIVE-15324:
------------------------------------

It's at lease unclear to me if such a change makes sense. UDF round() is to adjust decimal
point and it should have a definitive return type. If the given scale is variable, we don't
even know the return type. For example, round(decimal(10, 4), x) gives return type as decimal
(8, 2) when x=2, decimal(9, 3) when x = 1. If each row produces a different type, then what's
the result type?

> Enable round() function to accept scale argument as non-constants
> -----------------------------------------------------------------
>
>                 Key: HIVE-15324
>                 URL: https://issues.apache.org/jira/browse/HIVE-15324
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-15324.1.patch, HIVE-15324.2.patch, HIVE-15324.patch
>
>
> round() function should accept  scale argument as non-constants, it will enable queries
like: 
> {quote}
> create table sampletable(c double, d int);
> select round(c,d) from sampletable;
> {quote}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message