ALTER LOCATION

Purpose

This statement is used to modify the properties of a Location object.

Privilege requirements

• Privilege:

  To execute the ALTER LOCATION statement, the current user must have the CREATE LOCATION privilege. For more information about OceanBase Database privileges, see Privilege classification in Oracle mode.

• Credential:

  The provided ACCESSID and ACCESSKEY must have valid access permissions to the target storage service.

Syntax

ALTER LOCATION location_name SET 
    {URL = 'file_path'
    | CREDENTIAL = (credential_list)
    };

credential_list:
    ACCESSID = 'string'
    ACCESSKEY = 'string'
    HOST = 'string'
    [S3_REGION = 'string']
    [PRINCIPAL = 'string']
    [KEYTAB = 'string']
    [KRB5CONF = 'string']
    [CONFIGS = 'string']
    [USERNAME = 'string']

Parameters

file_path

The path for storing external table files can be in the following formats:

• Local path: URL = 'file://local_file_path', where local_file_path can be a relative or absolute path.

• HDFS path: URL = 'hdfs://localhost:port/PATH', where localhost specifies the HDFS address, port specifies the HDFS port number, and PATH specifies the directory path in HDFS.

• Object storage (OSS/S3) path: URL = '{oss | s3}://bucket/remote_file_path'.

credential_list

• ACCESSID: the AccessKey ID for accessing object storage.
• ACCESSKEY: the AccessKey secret for accessing object storage.
• HOST: the host address for accessing object storage.
• S3_REGION: the service region for S3 object storage. This is an optional parameter.
• PRINCIPAL: the login user for the target HDFS cluster with Kerberos. This is an optional parameter.
• KEYTAB: the authentication key file path for the target HDFS cluster with Kerberos. This is an optional parameter.
• KRB5CONF: the file path for using Kerberos in the target HDFS cluster with Kerberos. This is an optional parameter.
• CONFIGS: additional cluster configurations for the target HDFS cluster with Kerberos. This is an optional parameter.
• USERNAME: the unique identifier for the user in the target HDFS cluster with Kerberos. This is an optional parameter.

Examples

Modify the CREDENTIAL information of the test_location_oss Location object.

obclient> CREATE LOCATION test_location_oss
    URL = 'oss://dir'
    CREDENTIAL = (
        ACCESSID = '******'
        ACCESSKEY = '******'
        HOST = '******'
        );

References

For information about viewing files under a Location object, see SHOW.