runtime_filter_type specifies the runtime filter type at the tenant level.
Note
This variable is introduced since OceanBase Database V4.2.0.
| Attribute |
Description |
| Type |
Varchar |
| Default value |
BLOOM_FILTER,RANGE,IN |
| Value range |
BLOOM_FILTER: filters data by using a runtime filter of the Bloom Filter type. The data that is not within the value range specified by the Bloom Filter runtime filter is filtered out.RANGE: filters data by using a runtime filter of the RANGE type, which specifies a value range that covers the maximum and minimum values in a build table. The data that is not within the value range is filtered out.IN: filters data by using a runtime filter of the IN type, whose internal data structure is a hash table. The data that is not contained in the hash table is filtered out.- Empty: If the variable value is empty, the Runtime Filter feature is disabled.
Note
If you want to use runtime filters, you must specify at least one of the BLOOM_FILTER, RANGE, and IN values.
|
| Applicable scope |
|
| Read-only |
No |
| Plan generation affected |
Yes |
| Effective only after restart |
No |
Examples
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';
