joined_block_split_single_row
Allow to chunk hash join result by rows corresponding to single row from left table. This may reduce memory usage in case of row with many matches in right table, but may increase CPU usage. Note thatmax_joined_block_size_rows != 0 is mandatory for this setting to have effect.
The max_joined_block_size_bytes combined with this setting is helpful to avoid excessive memory usage in case of skewed data with some large rows having many matches in right table.