[
https://issues.apache.org/jira/browse/HIVE-17375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16163075#comment-16163075
]
Zoltan Haindrich commented on HIVE-17375:
-----------------------------------------
[~leftylev] Its a somewhat uncommon corner case in which it behaved differently
- ( if the group had only 1 element )
I think we haven't noted the correction of bugs like this earlier...but if you
think it would be better to note it; then I can add a note in the wiki about
it! :)
> stddev_samp,var_samp standard compliance
> ----------------------------------------
>
> Key: HIVE-17375
> URL: https://issues.apache.org/jira/browse/HIVE-17375
> Project: Hive
> Issue Type: Sub-task
> Components: SQL
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Minor
> Fix For: 3.0.0
>
> Attachments: HIVE-17375.1.patch, HIVE-17375.2.patch
>
>
> these two udaf-s are returning 0 in case of only one element - however the
> stadard requires NULL to be returned
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
