You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Gopinath (Jira)" <ji...@apache.org> on 2022/11/13 09:49:00 UTC

[jira] [Assigned] (HIVE-26731) UDF trunc produces incorrect result for higher values

     [ https://issues.apache.org/jira/browse/HIVE-26731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gopinath reassigned HIVE-26731:
-------------------------------


> UDF trunc produces incorrect result for higher values
> -----------------------------------------------------
>
>                 Key: HIVE-26731
>                 URL: https://issues.apache.org/jira/browse/HIVE-26731
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Gopinath
>            Assignee: Gopinath
>            Priority: Major
>
> The trunc function produces an incorrect result for higher values。
> The test is as follows:
>  
>  
> {{{quote}}}
> 0: jdbc:hive2://localost> select trunc(123456711889.122345897, 8);
> +----------------------------------+
> |               _c0                |
> +----------------------------------+
> | -61010728847.97317027  |
> +----------------------------------+{{{}{}}}{{{}{}}}
> {{{}{}}}{{{}{quote}{}}}
>  
> Expected Value -  123456711889.12234589 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)