[docs](function) support aggregrate function regr_slope regr_intercept

[Yoruet]

trafficstars

Versions

• [x] dev
• [x] 3.0
• [ ] 2.1
• [ ] 2.0

Languages

• [x] Chinese
• [x] English

https://github.com/apache/doris/pull/41240

[KassieZ]

hi, please update dev version as well

[KassieZ]

For SQL reference, please fix the title format, you could refer to this sample :

---

{ "title": "FUNCTION_NAME", "language": "en" }

Description

FUNCTION_NAME is used to XXXXXXX for XXXXX。(A brief description of the function and its purpose. Describe the use cases and scenarios where this function can be beneficial.)

Since Doris vXXX is supported XXXX。(Optional)

Syntax

FunctionName(param1, param2, ...)

Paremeters

• param1 (DataType1): Brief description of the parameter and its role in the function.

• param2 (DataType2): Same.

• ...

Returned values

Returned data type: ReturnType

• If XXXcase1 then returned XXXX value1；

• If XXXXcase2 then returned XXXX value2；

Examples

-- Example 1: Basic Usage
SELECT FunctionName('example_value') FROM dummy_table;  
  
-- Example 2: Usage in query
SELECT column1, FunctionName(column2) AS result_column FROM example_table;  
  
-- Example 3: Advanced usage
SELECT column1, FunctionName(OTHER_FUNCTION(column2)) AS combined_result FROM example_table;

Usage notes

• List any known limitations or restrictions on the usage of function.

• This could include data size limits, unsupported data types, or specific behavior that may not be intuitive.

Related commands

FUNCTION_NAME_2、FUNCTION_NAME_3、More...

References

For more details about XXXX, please refere to XXXXX

[Yoruet]

hi, please update dev version as well

Sorry, I'm not sure what this means. I have added doc in version-3.0.

[KassieZ]

hi, please update dev version as well

Sorry, I'm not sure what this means. I have added doc in version-3.0.

Please also update EN docs on the directory : doris-website/doris-website/docs and CN docs on the directory : /doris-website/i18n/zh-CN/docusaurus-plugin-content-docs/current

[Yoruet]

hi, please update dev version as well

Sorry, I'm not sure what this means. I have added doc in version-3.0.

Please also update EN docs on the directory : doris-website/doris-website/docs and CN docs on the directory : /doris-website/i18n/zh-CN/docusaurus-plugin-content-docs/current

I have added docs:docs/sql-manual/sql-functions/aggregate-functions/regr_intercept.md , docs/sql-manual/sql-functions/aggregate-functions/regr_slope.md , i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/regr_intercept.md, i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/regr_slope.md

[KassieZ]

Thank you for the contribution, please also fix the conflicts.

[zclllyybb]

has some wrong. replaced by https://github.com/apache/doris-website/pull/2443