ALTER EXTERNAL SCHEMA

Updated on 2025-03-07 GMT+08:00

View PDF

Function

Modifies EXTERNAL SCHEMA. This syntax is supported only in 8.3.0 and later versions.

Syntax

Modifies an external schema based on the specified name.

      
         ALTER EXTERNAL SCHEMA schema_name 
    WITH [ SOURCE source_name ]
         [ DATABASE 'database_name' ]
         [ SERVER server_name ]
         [ CATALOG 'catalog_name' ]
         [ OPTIONS ( { option_name ' value ' } [, ...] ) ]
         [ METAADDRESS 'address']
         [ CONFIGURATION 'confpath'];

Parameter Description

schema_name
Name of the external schema to be modified.
SOURCE
Type of the external metadata storage engine. Currently, source_type can only be dli, lakeformation, or hive.
DATABASE
Database corresponding to the external schema.
SERVER
Value range: an existing foreign server whose type is lf, dli, obs, or hdfs.

You can associate an external schema with a foreign server to access external data.
CATALOG
Catalog to be accessed in LakeFormation.
OPTIONS
Foreign table parameters. This function is supported only by 8.3.0 and later versions.

dli_project_id

Specifies the project ID corresponding to DLI. You can obtain the project ID from the management console. This parameter is available only when the server type is DLI.
METAADDRESS
Hivemetastore communication interface. This parameter is supported only by 9.1.0 and later versions.
CONFIGURATION
Path for storing hivemetastore configuration files. This parameter is supported only by 9.1.0 and later versions.

NOTE:

If objects in the schema on the current search path are with the same name, specify the schemas different objects are in. You can run the SHOW SEARCH_PATH command to check the schemas on the current search path.

Examples

Modify the database and FOREIGN SERVER corresponding to ex1.

    
       ALTER EXTERNAL SCHEMA ex1
    WITH DATABASE 'demo'
         SERVER my_server;

Parent topic: DDL Syntax

Previous topic: ALTER EXCEPT RULE

Next topic: ALTER FOREIGN TABLE (GDS Import and Export)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel