matrixorigin / matrixorigin/matrixone

[Tech Request]: Advance aggregate functions, regression and polynomial fitting

Open
#10,182 3 comments 0 reactions 1 assignee Claimed by @ck89119 View on GitHub
attention/doc-influence attention/needs-doc-discussion deferred kind/tech-request priority/p1 source/dev team/c2
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same feature request?

- [X] I have checked the existing issues.

### Is your feature request related to a problem?

_No response_

### Describe the feature you'd like

Linear and higher degree polynomial fitting. PostgresSQL/Snowflake/Oracle have linear regression regr_XXX functions. For example, https://docs.snowflake.com/en/sql-reference/functions/regr_intercept or [
](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/REGR_-Linear-Regression-Functions.html#GUID-A675B68F-2A88-4843-BE2C-FCDE9C65F9A9)

It is also useful to fix different functions, like higher degree polynomial, exponential, log, etc etc.

Lets' start from linear

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.