Join table engine.
If a query contains multiple joins, ClickHouse checks this setting for every intermediate result.
ClickHouse can proceed with different actions when the limit is reached. Use the join_overflow_mode setting to choose the action.
Possible values:
Default value: 0.
Limits the size in bytes of the hash table used when joining tables.
This settings applies to SELECT … JOIN operations and Join table engine.
If the query contains joins, ClickHouse checks this setting for every intermediate result.
ClickHouse can proceed with different actions when the limit is reached. Use join_overflow_mode settings to choose the action.
Possible values:
Default value: 0.
Defines what action ClickHouse performs when any of the following join limits is reached:
Possible values:
THROW
— ClickHouse throws an exception and breaks operation.BREAK
— ClickHouse breaks operation and doesn’t throw an exception.Default value: THROW
.
See Also
Enables or disables execution of GROUP BY
clauses in external memory. See GROUP BY in external memory.
Possible values:
GROUP BY
in external memory disabled.Default value: 0.
Rating: 3.7 - 6 votes
Was this content helpful?