You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2021/03/03 08:07:00 UTC

[jira] [Created] (FLINK-21579) Support "SHOW USER FUNCTIONS" statement

Jark Wu created FLINK-21579:
-------------------------------

             Summary: Support "SHOW USER FUNCTIONS" statement
                 Key: FLINK-21579
                 URL: https://issues.apache.org/jira/browse/FLINK-21579
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / API, Table SQL / Client
            Reporter: Jark Wu


Currently, the {{SHOW FUNCTIONS}} lists all user-defined and built-in functions which is very verbose. We already introduced {{listUserDefinedFunctions()}} method on {{TableEnvironment}}. I think we can introduce a dedicate syntax to show user-defined only functions which simply calls {{listUserDefinedFunctions()}}. That would be very useful. 

I propose to use {{SHOW USER FUNCTIONS}} which is also supported by Snowflake [1] and Spark[2].


[1]: https://docs.snowflake.com/en/sql-reference/sql/show-user-functions.html
[2]: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-show-functions.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)