This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push: new 1b02f083fd3 [doc](udtf) remove some doc about udtf in branch2.0/2.1 (#1151) 1b02f083fd3 is described below commit 1b02f083fd3bba8b27c9d73c97a446882c8dfcdf Author: zhangstar333 <87313068+zhangstar...@users.noreply.github.com> AuthorDate: Wed Sep 25 20:56:29 2024 +0800 [doc](udtf) remove some doc about udtf in branch2.0/2.1 (#1151) # Versions as UDTF is supported starting from Doris version 3.0 - [ ] dev - [ ] 3.0 - [x] 2.1 - [x] 2.0 # Languages - [x] Chinese - [x] English --- .../query/udf/java-user-defined-function.md | 27 --------------------- .../query/udf/java-user-defined-function.md | 27 --------------------- .../query/udf/java-user-defined-function.md | 28 ---------------------- .../query/udf/java-user-defined-function.md | 28 ---------------------- 4 files changed, 110 deletions(-) diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/udf/java-user-defined-function.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/udf/java-user-defined-function.md index 5ac6ab8773f..4fa7b165115 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/udf/java-user-defined-function.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/udf/java-user-defined-function.md @@ -70,15 +70,6 @@ CREATE AGGREGATE FUNCTION middle_quantiles(DOUBLE,INT) RETURNS DOUBLE PROPERTIES UDTF 自 Doris 3.0 版本开始支持 ::: -```sql -CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string> PROPERTIES ( - "file"="file:///pathTo/java-udaf.jar", - "symbol"="org.apache.doris.udf.demo.UDTFStringTest", - "always_nullable"="true", - "type"="JAVA_UDF" -); -``` - ## 使用 UDF 用户使用 UDF 必须拥有对应数据库的 `SELECT` 权限。 @@ -350,24 +341,6 @@ public class MedianUDAF { ``` -### UDTF - -UDTF 和 UDF 函数一样,需要用户自主实现一个 `evaluate` 方法, 但是 UDTF 函数的返回值必须是 Array 类型。 - -另外Doris中表函数会因为 `_outer` 后缀有不同的表现,可查看[OUTER 组合器](../../sql-manual/sql-functions/table-functions/explode-numbers-outer.md) - -```JAVA -public class UDTFStringTest { - public ArrayList<String> evaluate(String value, String separator) { - if (value == null || separator == null) { - return null; - } else { - return new ArrayList<>(Arrays.asList(value.split(separator))); - } - } -} -``` - ## 最佳实践 ### static 变量加载 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/udf/java-user-defined-function.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/udf/java-user-defined-function.md index 23dc6302a09..417a42bbfcd 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/udf/java-user-defined-function.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/udf/java-user-defined-function.md @@ -70,15 +70,6 @@ CREATE AGGREGATE FUNCTION middle_quantiles(DOUBLE,INT) RETURNS DOUBLE PROPERTIES UDTF 自 Doris 3.0 版本开始支持 ::: -```sql -CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string> PROPERTIES ( - "file"="file:///pathTo/java-udaf.jar", - "symbol"="org.apache.doris.udf.demo.UDTFStringTest", - "always_nullable"="true", - "type"="JAVA_UDF" -); -``` - ## 使用 UDF 用户使用 UDF 必须拥有对应数据库的 `SELECT` 权限。 @@ -350,24 +341,6 @@ public class MedianUDAF { ``` -### UDTF - -UDTF 和 UDF 函数一样,需要用户自主实现一个 `evaluate` 方法, 但是 UDTF 函数的返回值必须是 Array 类型。 - -另外Doris中表函数会因为 `_outer` 后缀有不同的表现,可查看[OUTER 组合器](../../sql-manual/sql-functions/table-functions/explode-numbers-outer.md) - -```JAVA -public class UDTFStringTest { - public ArrayList<String> evaluate(String value, String separator) { - if (value == null || separator == null) { - return null; - } else { - return new ArrayList<>(Arrays.asList(value.split(separator))); - } - } -} -``` - ## 最佳实践 ### static 变量加载 diff --git a/versioned_docs/version-2.0/query/udf/java-user-defined-function.md b/versioned_docs/version-2.0/query/udf/java-user-defined-function.md index f677d71ec6c..a6616cbed7a 100644 --- a/versioned_docs/version-2.0/query/udf/java-user-defined-function.md +++ b/versioned_docs/version-2.0/query/udf/java-user-defined-function.md @@ -70,15 +70,6 @@ CREATE AGGREGATE FUNCTION middle_quantiles(DOUBLE,INT) RETURNS DOUBLE PROPERTIES UDTF is supported starting from Doris version 3.0. ::: -```sql -CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string> PROPERTIES ( - "file"="file:///pathTo/java-udaf.jar", - "symbol"="org.apache.doris.udf.demo.UDTFStringTest", - "always_nullable"="true", - "type"="JAVA_UDF" -); -``` - ## Using UDF To utilize UDFs, users must possess the `SELECT` privilege for the corresponding database. @@ -350,25 +341,6 @@ public class MedianUDAF { } ``` - -### UDTF - -Similar to UDFs, UDTFs require users to implement an `evaluate` method. However, the return value of a UDTF must be of the Array type. - -Additionally, table functions in Doris may exhibit different behaviors due to the `_outer` suffix. For more details, refer to [OUTER combinator](../../sql-manual/sql-functions/table-functions/explode-numbers-outer.md). - -```JAVA -public class UDTFStringTest { - public ArrayList<String> evaluate(String value, String separator) { - if (value == null || separator == null) { - return null; - } else { - return new ArrayList<>(Arrays.asList(value.split(separator))); - } - } -} -``` - ## Best Practices ### Loading static variables diff --git a/versioned_docs/version-2.1/query/udf/java-user-defined-function.md b/versioned_docs/version-2.1/query/udf/java-user-defined-function.md index 967ac667079..44ea69429a1 100644 --- a/versioned_docs/version-2.1/query/udf/java-user-defined-function.md +++ b/versioned_docs/version-2.1/query/udf/java-user-defined-function.md @@ -70,15 +70,6 @@ CREATE AGGREGATE FUNCTION middle_quantiles(DOUBLE,INT) RETURNS DOUBLE PROPERTIES UDTF is supported starting from Doris version 3.0. ::: -```sql -CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string> PROPERTIES ( - "file"="file:///pathTo/java-udaf.jar", - "symbol"="org.apache.doris.udf.demo.UDTFStringTest", - "always_nullable"="true", - "type"="JAVA_UDF" -); -``` - ## Using UDF To utilize UDFs, users must possess the `SELECT` privilege for the corresponding database. @@ -350,25 +341,6 @@ public class MedianUDAF { } ``` - -### UDTF - -Similar to UDFs, UDTFs require users to implement an `evaluate` method. However, the return value of a UDTF must be of the Array type. - -Additionally, table functions in Doris may exhibit different behaviors due to the `_outer` suffix. For more details, refer to [OUTER combinator](../../sql-manual/sql-functions/table-functions/explode-numbers-outer.md). - -```JAVA -public class UDTFStringTest { - public ArrayList<String> evaluate(String value, String separator) { - if (value == null || separator == null) { - return null; - } else { - return new ArrayList<>(Arrays.asList(value.split(separator))); - } - } -} -``` - ## Best Practices ### Loading static variables --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org