[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17529310#comment-17529310 ]
xiong duan commented on CALCITE-1776: ------------------------------------- I run the same test SQL in agg.iq and here are some problems in PR: {noformat} 1:agg.iq about the CORR Funciton has a wrong result: corr(SAL, COMM) as CORR(SAL, COMM) should be -0.6992097353323843 but is -2.423927082485599 2: agg.iq about the REGR_AVGX and REGR_AVGY Function has a wrong result. Looks like the result has swap. 3: agg.iq about the REGR_R2 has a wrong result.{noformat} > Implement CORR and REGR_* aggregate functions > --------------------------------------------- > > Key: CALCITE-1776 > URL: https://issues.apache.org/jira/browse/CALCITE-1776 > Project: Calcite > Issue Type: New Feature > Reporter: Dmitri Shtilman > Priority: Minor > Labels: pull-request-available > > 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] -- This message was sent by Atlassian Jira (v8.20.7#820007)