gatorsmile commented on a change in pull request #25553: [SPARK-28797][DOC]
Document DROP FUNCTION statement in SQL Reference.
URL: https://github.com/apache/spark/pull/25553#discussion_r324471741
##########
File path: docs/sql-ref-syntax-ddl-drop-function.md
##########
@@ -19,4 +19,64 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+`DROP FUNCTION` statement drops a temporary or user defined function(UDF). An
exception will be thrown if the function does not exist
+ in the system.
+
+### Syntax
+{% highlight sql %}
+DROP [TEMPORARY] FUNCTION [IF EXISTS] [db_name.]function_name;
+{% endhighlight %}
+
+
+### Parameters
+
+<dl>
+ <dt><code><em>function_name</em></code></dt>
+ <dd>The name of an existing function.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>TEMPORARY</em></code></dt>
+ <dd>Should be used to delete the `temporary` function.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>IF EXISTS</em></code></dt>
+ <dd>If specified, no exception is thrown when the function does not
exist.</dd>
+</dl>
+
+### Example
+{% highlight sql %}
+-- Create a permanent function `test_avg`
+CREATE FUNCTION test_avg as
'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage';
+
+-- List user functions
+SHOW user functions;
+ +-------------------+
+ | function |
+ +-------------------+
+ | default.test_avg |
+ +-------------------+
+
+-- Drop Permanent function
+DROP FUNCTION test_avg;
Review comment:
Can we document the behavior when there exists a temporary function whose
name is also `test_avg`?
----------------------------------------------------------------
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]
