[CALCITE-1776] Implement CORR and REGR_* aggregate functions

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Dmitri Shtilman
• Created: 05/May/17 20:22
• Updated: 11/Oct/23 05:56

Description

Implement correlation coefficient aggregate: CORR

As well as the missing regression aggregates:
REGR_SLOPE, REGR_INTERCEPT, REGR_COUNT, REGR_R2, REGR_AVGX, REGR_AVGY, REGR_SXY

For reference, REGR_SXX and REGR_SYY have been added in CALCITE-422

Issue Links

• is duplicated by: CALCITE-5114 SqlParseException for Spark's "corr" function
• links to: Pull Request #793