[
https://issues.apache.org/jira/browse/HIVE-26314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wechar updated HIVE-26314:
--------------------------
Description:
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 [ OR REPLACE ] [ TEMPORARY ] FUNCTION [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.
was:
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 [ OR REPLACE ] [ TEMPORARY ] FUNCTION [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.
> 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
>
>
> 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 [ OR REPLACE ] [ TEMPORARY ] FUNCTION [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)
