runtime_filter_type is used to set the tenant-level Runtime Filter type.
Note
This variable is available starting with V4.2.0.
Attribute |
Description |
|---|---|
| Parameter type | varchar |
| Default Value | BLOOM_FILTER,RANGE,IN |
| Value range |
NoteIf the value is BLOOM_FILTER, RANGE, or IN, at least one of these options must be selected. |
| Effective Scope |
|
| Read-only | No |
| Affect plan generation? | Yes |
| Whether restart is required for the change to take effect | No |
Example
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';