The JOIN_ROWS_PRODUCED_LIMIT query option limits the number of join
rows produced by a join node and is used to prevent runaway join queries. A query
is canceled when any one of the joins in the query produces more rows (totaled across
all instances of that join) than the specified limit set by the
JOIN_ROWS_PRODUCED_LIMIT option.
This limit is checked periodically, so it is possible that the actual number of rows produced may be slightly higher than the limit.
The default value of 0 specifies that there is no limit on the number of
join rows produced.
Type: BIGINT
Allowed values: 0 or positive numbers
Default: 0
Added in: Impala 4.0