Settings | ClickHouse Documentation
clickhouse.com › docs › enClickHouse applies this setting when the query contains the product of distributed tables, i.e. when the query for a distributed table contains a non-GLOBAL subquery for the distributed table. Only applied for IN and JOIN subqueries. Only if the FROM section uses a distributed table containing more than one shard.