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/12/20 11:22:00 UTC
[jira] [Updated] (HIVE-25653) Incorrect results returned by STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.
[ https://issues.apache.org/jira/browse/HIVE-25653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Sharma updated HIVE-25653:
---------------------------------
Description:
Description
*Script*-
create table test ( col1 decimal );
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
was:
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
> Incorrect results returned by STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-25653
> URL: https://issues.apache.org/jira/browse/HIVE-25653
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Affects Versions: 3.1.0, 3.1.2
> Reporter: Ashish Sharma
> Assignee: Ashish Sharma
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> Description
> *Script*-
> create table test ( col1 decimal );
> 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)