You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lexluo09 (via GitHub)" <gi...@apache.org> on 2023/03/20 10:03:44 UTC

[GitHub] [doris] lexluo09 opened a new pull request, #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

lexluo09 opened a new pull request, #17964:
URL: https://github.com/apache/doris/pull/17964

   # Proposed changes
   
   The global udf support ('show functions'/'show create') operation, to show the details of the global udf.
   
   
   ## Problem summary
   
   Solution
   1、 add the global keyword.
   
   SHOW [GLOBAL] [FULL] [BUILTIN] FUNCTIONS [IN|FROM db] [LIKE 'function_pattern']
   
   SHOW CREATE GLOBAL FUNCTION function_name(arg_type [, ...]) [FROM db_name]];
   
   
   2、show the details of the  global udf.
   
   
   ![image](https://user-images.githubusercontent.com/39718951/226307238-20d14a3b-aa84-437c-87a6-a8346580d199.png)
   
   ![image](https://user-images.githubusercontent.com/39718951/226307266-d13c091b-7740-4035-b9fb-b25daf5671e1.png)
   
   
   
   ## Checklist(Required)
   
   * [x] Does it affect the original behavior
   * [√ ] Has unit tests been added
   * [√] Has document been added or modified
   * [x ] Does it need to update dependencies
   * [√] Is this PR support rollback (If NO, please explain WHY)
   
   ## Further comments
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1480676091

   run p0
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] github-actions[bot] commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1479788671

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] morningman commented on a diff in pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on code in PR #17964:
URL: https://github.com/apache/doris/pull/17964#discussion_r1143335834


##########
docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-CREATE-FUNCTION.md:
##########
@@ -37,13 +37,14 @@ SHOW CREATE FUNCTION
 语法：
 
 ```sql
-SHOW CREATE FUNCTION function_name(arg_type [, ...]) [FROM db_name]];
+SHOW CREATE [GLOBAL] FUNCTION function_name(arg_type [, ...]) [FROM db_name]];
 ```
 
 说明：
-          1. `function_name`: 要展示的函数名称
-          2. `arg_type`: 要展示的函数的参数列表
-          3. 如果不指定 db_name，使用当前默认 db
+          1. `global`: 要展示的是全局函数
+          2. `function_name`: 要展示的函数名称
+          3. `arg_type`: 要展示的函数的参数列表
+          4. 如果不指定 db_name，使用当前默认 db

Review Comment:
   Add a entry to explain that "global" keyword is only available after v2.0



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1480813787

   
   run p1


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] morningman merged pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #17964:
URL: https://github.com/apache/doris/pull/17964


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1479581094

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] github-actions[bot] commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1479788592

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1480523695

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] morningman commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1482159438

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] github-actions[bot] commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1481352921

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1482322817

   
   run buildall
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] lexluo09 commented on pull request #17964: [enhancement](UDF) The user defined functions support global ('show functions'/'show create') operation

Posted by "lexluo09 (via GitHub)" <gi...@apache.org>.
lexluo09 commented on PR #17964:
URL: https://github.com/apache/doris/pull/17964#issuecomment-1480672755

   
   run buildall
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org