[
https://issues.apache.org/jira/browse/HAWQ-708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lei Chang closed HAWQ-708.
--------------------------
Resolution: Fixed
Code has been merged
> Consume latest GPORCA features up to version 1.630
> --------------------------------------------------
>
> Key: HAWQ-708
> URL: https://issues.apache.org/jira/browse/HAWQ-708
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Optimizer
> Reporter: xin zhang
> Assignee: Amr El-Helw
>
> There are additional GPORCA features benefiting the HAWQ community, and this
> ticket is to bump the GPORCA from version 1.627 to 1.630. Here is list of new
> features in GPORCA:
> -- 1.628 and rename EatMalloc to EatTracker
> Better memory tracking.
> -- 1.629 to include new GUC for Join Exploration
> New GUC optimizer_join_arity_for_associativity_commutativity is added to
> control Join exploration, hence speed up optimization time [#116333899]
> For example, `set optimizer_join_arity_for_associativity_commutativity=x`
> will
> hint at the optimizer to stop exploring join associativity and join
> commutativity transformations when an n-ary join operator has more than
> x children during optimization, pruning quite a bit of the search space.
> -- 1.630 to fix CTE Predicate pushdown
> This fix will prevent predicate pushdown with volatile function like
> random(), which caused wrong result if predicates were duplicated.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
