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

Posted to issues@hive.apache.org by "Ashish Sharma (Jira)" <ji...@apache.org> on 2021/11/12 12:20:00 UTC

[jira] [Work started] (HIVE-25693) Vector implementation return Incorrect results for STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.

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

Work on HIVE-25693 started by Ashish Sharma.
--------------------------------------------
> Vector implementation return Incorrect results for STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-25693
>                 URL: https://issues.apache.org/jira/browse/HIVE-25693
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ashish Sharma
>            Assignee: Ashish Sharma
>            Priority: Major
>
> Description
> Script-
> create table test ( col1 int );
> insert into values ('10230.72'),('10230.72'),('10230.72'),('10230.72'),('10230.72'),('10230.72'),('10230.72');
> select STDDEV_SAMP(col1) AS STDDEV_6M , STDDEV(col1) as STDDEV ,STDDEV_POP(col1) as STDDEV_POP from test;
> Result-
> STDDDEV_SAMP STDDEV STDDEV_POP
> 5.940794514955821E-13 5.42317860890711E-13 5.42317860890711E-13
> Expected-
> STDDDEV_SAMP STDDEV STDDEV_POP
> 0 0 0



--
This message was sent by Atlassian Jira
(v8.20.1#820001)