[
https://issues.apache.org/jira/browse/HIVE-26314?focusedWorklogId=780611&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-780611
]
ASF GitHub Bot logged work on HIVE-26314:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 12/Jun/22 12:57
Start Date: 12/Jun/22 12:57
Worklog Time Spent: 10m
Work Description: wecharyu opened a new pull request, #3360:
URL: https://github.com/apache/hive/pull/3360
### What changes were proposed in this pull request?
Hive SQL does not support **ALTER FUNCTION** yet, we can refer to the
**CREATE [OR REPLACE] FUNCTION** of
[Spark](https://spark.apache.org/docs/3.1.2/sql-ref-syntax-ddl-create-function.html)
to implement the alter function .
### Why are the changes needed?
To support alter udf.
### Does this PR introduce _any_ user-facing change?
Yes, need change the DDL statement document in the [Hive
WIKI](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/ReloadFunction).
### How was this patch tested?
We add a qtest `create_or_replace_function.q`, can be test by command:
```bash
mvn test -Dtest=TestMiniLlapLocalCliDriver
-Dqfile=create_or_replace_function.q
```
Issue Time Tracking
-------------------
Worklog Id: (was: 780611)
Remaining Estimate: 0h
Time Spent: 10m
> Support alter function in Hive DDL
> ----------------------------------
>
> Key: HIVE-26314
> URL: https://issues.apache.org/jira/browse/HIVE-26314
> Project: Hive
> Issue Type: Task
> Components: Hive
> Affects Versions: 4.0.0-alpha-1
> Reporter: Wechar
> Assignee: Wechar
> Priority: Minor
> Fix For: 4.0.0-alpha-2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Hive SQL does not support {{*ALTER FUNCTION*}} yet, we can refer to the
> {{*CREATE [OR REPLACE] FUNCTION*}} of
> [Spark|https://spark.apache.org/docs/3.1.2/sql-ref-syntax-ddl-create-function.html]
> to implement the alter function .
> {code:sql}
> CREATE [ TEMPORARY ] FUNCTION [ OR REPLACE ] [IF NOT EXISTS ]
> [db_name.]function_name AS class_name
> [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> {code}
> * *OR REPLACE*
> If specified, the resources for the function are reloaded. This is mainly
> useful to pick up any changes made to the implementation of the function.
> This parameter is mutually exclusive to {{*IF NOT EXISTS*}} and can not be
> specified together.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
