[HIVE-25653] Incorrect results returned by STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.

• Type: Improvement
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0, 3.1.2
• Component/s: UDF
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Ashish Sharma
• Reporter: Ashish Sharma
• Created: 27/Oct/21 08:14
• Updated: 22/Dec/21 11:08

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

Issue Links

• is related to: HIVE-25693 Vector implementation return Incorrect results for STDDEV, STDDEV_SAMP, STDDEV_POP for floating point data types.
• links to: GitHub Pull Request #2760
• links to: GitHub Pull Request #2897