gatorsmile commented on a change in pull request #25539: 
[SPARK-28808][DOCS][SQL] Document SHOW FUNCTIONS in SQL Reference.
URL: https://github.com/apache/spark/pull/25539#discussion_r317460486
 
 

 ##########
 File path: docs/sql-ref-syntax-aux-show-functions.md
 ##########
 @@ -19,4 +19,47 @@ license: |
   limitations under the License.
 ---
 
-**This page is under construction**
+### Description
+Returns the list of functions after applying an optional regex pattern.
+Three optional parameters `SYSTEM`, `USER`, `ALL` may be specified to list
+system functions, user defined function or both user and system defined
+funtions respectively. Given Spark supports hundreds of functions, this
+statement in conjuction with [describe 
function](sql-ref-syntax-aux-describe-function.html)
+may be used to quickly find the function and understand its usage.
+
+### Syntax
+{% highlight sql %}
+SHOW [USER|SYSTEM|ALL] FUNCTIONS ([LIKE] qualified_function_name | 
regex_pattern)
+qualified_function_name:= [db.]function_name
 
 Review comment:
   Is this still needed? How about only doing it in the section `### 
Parameters`?

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to