[
https://issues.apache.org/jira/browse/IMPALA-12794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18016884#comment-18016884
]
Michael Smith edited comment on IMPALA-12794 at 8/28/25 8:59 PM:
-----------------------------------------------------------------
One of the Hive descriptions is wrong here.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF states
regr_avgx(y, x) is "Equivalent to avg(dependent)."
https://github.com/apache/hive/blob/rel/release-3.1.3/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFBinarySetFunctions.java#L163
states "evaluates the average of the independent variable".
was (Author: JIRAUSER288956):
The description is wrong here. regr_avgx(y, x) computes the average of the
*dependent* state according to the Hive docs. regr_avgy would be the
independent state.
> Average Independent Variable Calculator for Linear Regression: regr_avgx()
> support in Impala
> --------------------------------------------------------------------------------------------
>
> Key: IMPALA-12794
> URL: https://issues.apache.org/jira/browse/IMPALA-12794
> Project: IMPALA
> Issue Type: New Feature
> Reporter: Pranav Yogi Lodha
> Assignee: Pranav Yogi Lodha
> Priority: Major
>
> regr_avgx(y, x) computes the average of the independent variable after
> eliminating pairs containing NULL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
