Page History

...

Whether to push a limit through left/right outer join. If the value is true and the size of the outer input is reduced enough (as specified in hive.optimize.limitjointranspose.reductionpercentage and hive.optimize.limitjointranspose.reductiontuples), the limit is pushed to the outer input; to remain semantically correct, the limit is kept on top of the join too.

...

• Default Value: 1.0
• Added In: Hive 2.0.0 with HIVE-11684

When hive.optimize.limitjointranspose is true, this variable specifies the minimal percentage (fractional) reduction of the size of the outer input of the join that we the optimizer should get in order to apply the rule.

...

• Default Value: 0
• Added In: Hive 2.0.0 with HIVE-11684

When hive.optimize.limitjointranspose is true, this variable specifies the minimal reduction in the number of tuples of the outer input of the join that you the optimizer should get in order to apply the rule.

...