SET_DATALAKE_CONFIG stored procedure

The SYSHADOOP.SET_DATALAKE_CONFIG stored procedure is used to set necessary configuration parameters for DATALAKE tables. With this stored procedure, you can set a new property value, update and existing property value, or delete a property value.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagram SET_DATALAKE_CONFIGcfg_file_typeproperty_nameproperty_value

Description

cfg_file_type
A VARCHAR(16) value that can be BIGSQL, CORE, HIVE, or NULL to indicate which configuration file should be enumerated. Passing NULL for this value will lists property keys and values for all DATALAKE configuration files.
property_name
A VARCHAR(512) name of the property to update. For example, scheduler.service.timeout. If a property with that name doesn't exist, it will be added to the configuration file.
property_value
A VARCHAR(2048) value of the new updated property.
NULL
A NULL value results in deletion of the property value.

Examples

To change the socket connection timeout in your core-site.xml file, run the following command:
CALL SYSHADOOP.SET_DATALAKE_CONFIG ('CORE','fs.s3a.connection.timeout', '200000')
To delete a property value, run the following command:
CALL SET_DATALAKE_CONFIG "('CORE', 'fs.s3a.bucket.default.path.style.access', NULL)"