apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.31k stars 3.21k forks source link

[Enhancement](doris-future) Support "REGR_" aggregation functions (PART IV) #38977

Open zclllyybb opened 1 month ago

zclllyybb commented 1 month ago

Search before asking

Description

We are going to support all regression functions in pg. You can see them in https://www.postgresql.org/docs/16/functions-aggregate.html with regr_ prefix. And considring the difficulty of this task, it will be nice for community as "good first issue".

In this issue, you should implement function regr_sxx, regr_sxy, regr_syy

If you'd like to work on it, please comment to let me know. I'll help you to achieve this.

Solution

you can found an example of implementation of a aggregate function here

for the function with some common logic, you could use template or function to extract them(the common usage).

Are you willing to submit PR?

Code of Conduct

wyxxxcat commented 1 month ago

I want to try it, please assign it to me

meetmehta1198 commented 1 month ago

I want to work on it! Can you please assign it to me!

zclllyybb commented 1 month ago

I want to work on it! Can you please assign it to me!

there's already someone in front of you. but here's still two similar case https://github.com/apache/doris/issues/38976, https://github.com/apache/doris/issues/38975 is free now. you can choose one!

zclllyybb commented 1 month ago

I want to try it, please assign it to me

ok~