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_CONFIG'property_file_name''property_key_name''property_value'

Description

'property_file_name'
A VARCHAR(16) value that can be BIGSQL, CORE, or HIVE.
'property_key_name'
A VARCHAR(512) name of the property to update. For example, 'scheduler.service.timeout'. An non-existent property name results in adding that property.
'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)"