runtime_filter_type specifies the runtime filter type at the tenant level.
Note
This variable is available in OceanBase Database V4.2.0 and later.
| 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 |
Sample code
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';
