[
https://issues.apache.org/jira/browse/HIVE-25693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17444140#comment-17444140
]
Stamatis Zampetakis commented on HIVE-25693:
--------------------------------------------
Hey [~ashish-kumar-sharma], as I wrote in HIVE-25653 we need to clarify if this
truly a bug or not. Please don't merge this PR till we reach consensus on
HIVE-25653.
> 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
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
