matrixorigin / matrixorigin/matrixone
[Tech Request]: Advance aggregate functions, regression and polynomial fitting
- 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
Assessment
This issue has not been assessed yet.