You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/08/24 16:36:00 UTC

[jira] [Commented] (IMPALA-11957) Implement Regression functions : regr_slope(), regr_intercept() and regr_r2()

    [ https://issues.apache.org/jira/browse/IMPALA-11957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17758653#comment-17758653 ] 

ASF subversion and git services commented on IMPALA-11957:
----------------------------------------------------------

Commit 20a9d2669c69f8e5b0a5c0b9487fa0212a00ad9c in impala's branch refs/heads/master from pranav.lodha
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=20a9d2669 ]

IMPALA-11957: Implement Regression functions: regr_slope(),
regr_intercept() and regr_r2()

The linear regression functions fit an ordinary-least-squares regression
line to a set of number pairs. They can be used both as aggregate and
analytic functions.

regr_slope() takes two arguments of numeric type and returns the slope
of the line.
regr_intercept() takes two arguments of numeric type and returns the
y-intercept of the regression line.
regr_r2() takes two arguments of numeric type and returns the
coefficient of determination (also called R-squared or goodness of fit)
for the regression.

Testing:
The functions are extensively tested and cross-checked with Hive. The
tests can be found in aggregation.test.
Change-Id: Iab6bd84ae3e0c02ec924c30183308123b951caa3
Reviewed-on: http://gerrit.cloudera.org:8080/19569
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> Implement Regression functions : regr_slope(), regr_intercept() and regr_r2()
> -----------------------------------------------------------------------------
>
>                 Key: IMPALA-11957
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11957
>             Project: IMPALA
>          Issue Type: Sub-task
>            Reporter: Pranav Yogi Lodha
>            Assignee: Pranav Yogi Lodha
>            Priority: Major
>
> The linear regression functions fit an ordinary-least-squares regression line
> to a set of number pairs which can be used both as aggregate and analytic functions.
>  * regr_slope() takes two arguments of numeric type and returns the slope of the line.
>  * regr_intercept() takes two arguments of numeric type and returns the y-intercept of the regression line.
>  * regr_r2() takes two arguments of numeric type and returns the coefficient of determination (also called R-squared or goodness of fit) for the regression.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org