Stamatis Zampetakis created HIVE-28310:
------------------------------------------
Summary: Disable
hive.optimize.join.disjunctive.transitive.predicates.pushdown by default
Key: HIVE-28310
URL: https://issues.apache.org/jira/browse/HIVE-28310
Project: Hive
Issue Type: Task
Components: CBO
Affects Versions: 4.0.0
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis
HIVE-25758 introduced
hive.optimize.join.disjunctive.transitive.predicates.pushdown to conditionally
limit some features of the HiveJoinPushTransitivePredicatesRule which are
rather unsafe and can lead to Hiveserver2 crashes (OOM, hangs, etc.).
The property was initially set to true to retain the old behavior and prevent
changes in performance for those queries that work fine as is. However, when
the property is true there are various known cases/queries that can bring down
HS2 completely. When this happens debugging, finding the root cause, and
turning off the property may require lots of effort from developers and users.
In this ticket, we propose to disable the property by default and thus limit
the optimizations performed by the rule (at least till a complete solution is
found for the known problematic cases).
This change favors HS2 stability at the expense of slight performance
degradation in certain queries.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
