Updated on 2025-05-29 GMT+08:00

User-defined Functions

udf_memory_limit

Parameter description: Controls the maximum physical memory that can be used when each database node executes UDFs. This parameter does not take effect in the current version. Use FencedUDFMemoryLimit and UDFWorkerMemHardLimit to control virtual memory used by fenced udf worker.

Parameter type: Integer

Unit: KB

Value range: 200 x 1024 to 2147483647

Default value: 204800 (that is, 200 MB)

Setting method: This is a POSTMASTER parameter. Set it based on instructions provided in Table 1. For example, if this parameter is set to 204800 without a unit, it indicates 204800 KB. If this parameter is set to 300MB, it indicates 300 MB. The unit must be KB, MB, or GB if required.

Setting suggestion: Retain the default value.

Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.

FencedUDFMemoryLimit

Parameter description: Specifies the virtual memory used by each fenced udf worker process.

Parameter type: Integer

Unit: KB

Value range: 0 to 2147483647

Default value: 0, indicating that the memory is not controlled.

Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1. For example, if this parameter is set to 200 without a unit, it indicates 200 KB. If this parameter is set to 3MB, it indicates 3 MB. The unit must be KB, MB, or GB if required.

Setting suggestion: Retain the default value.

Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.

UDFWorkerMemHardLimit

Parameter description: Specifies the maximum value of FencedUDFMemoryLimit.

Parameter type: Integer

Unit: KB

Value range: 0 to 2147483647

Default value: 1048576, that is, 1 GB.

Setting method: This is a POSTMASTER parameter. Set it based on instructions provided in Table 1. For example, if this parameter is set to 200 without a unit, it indicates 200 KB. If this parameter is set to 3MB, it indicates 3 MB. The unit must be KB, MB, or GB if required.

Setting suggestion: Retain the default value.

Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.