Page History

...

Exploit intra-query correlations. For details see the Correlation Optimizer design document.

hive.optimize.limitjointranspose

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

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.

hive.optimize.limitjointranspose.reductionpercentage

• 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 should get in order to apply the rule.

hive.optimize.limitjointranspose.reductiontuples

• 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 should get in order to apply the rule.

hive.optimize.sort.dynamic.partition

• Default Value: true in Hive 0.13.0 and 0.13.1; false in Hive 0.14.0 and later (HIVE-8151)
• Added In: Hive 0.13.0 with HIVE-6455

...