[
https://issues.apache.org/jira/browse/FLINK-21579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17295722#comment-17295722
]
Jark Wu commented on FLINK-21579:
---------------------------------
You can take FLINK-21297, FLINK-21299, FLINK-21298 as an example about how to
support a new syntax in both sql-parser, TableEnvironment, and SQL CLI.
> 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
> Priority: Major
>
> 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)
