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

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.3.0
• Epic Color: ghx-label-8
• Assignee: Pranav Yogi Lodha
• Reporter: Pranav Yogi Lodha
• Created: 01/Mar/23 07:35
• Updated: 15/Sep/23 18:03
• Resolved: 15/Sep/23 18:03

Description

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.