join_runtime_* session settings

These settings are available in system.settings and are autogenerated from source.

join_runtime_bloom_filter_bytes

Size in bytes of a bloom filter used as JOIN runtime filter (see enable_join_runtime_filters setting).

join_runtime_bloom_filter_hash_functions

Number of hash functions in a bloom filter used as JOIN runtime filter (see enable_join_runtime_filters setting).

join_runtime_bloom_filter_max_ratio_of_set_bits

If the number of set bits in a runtime bloom filter exceeds this ratio the filter is completely disabled to reduce the overhead.

join_runtime_filter_blocks_to_skip_before_reenabling

Number of blocks that are skipped before trying to dynamically re-enable a runtime filter that previously was disabled due to poor filtering ratio.

join_runtime_filter_exact_values_limit

Maximum number of elements in runtime filter that are stored as is in a set, when this threshold is exceeded it switches to bloom filter.

join_runtime_filter_from_fixed_hash_table

When the hash join build side was converted to a FixedHashMap (see enable_join_fixed_hash_table_conversion), use that hash map directly as the runtime filter.

join_runtime_filter_min_probe_rows

If, at query planning time, the probe side of a JOIN is estimated to produce no more than this number of rows, the JOIN runtime filter is not created. Building and applying a runtime filter for a tiny probe side costs more than it saves. Set to 0 to always create the runtime filter regardless of the estimated probe size.

join_runtime_filter_pass_ratio_threshold_for_disabling

If ratio of passed rows to checked rows is greater than this threshold the runtime filter is considered as poorly performing and is disabled for the next join_runtime_filter_blocks_to_skip_before_reenabling blocks to reduce the overhead.

join_runtime_filter_size_from_hash_table_stats

Use hash table size statistics collected from previous executions to size the JOIN runtime filter. When disabled, fall back to the fixed join_runtime_bloom_filter_bytes.