[jira] [Closed] (HAWQ-708) Consume latest GPORCA features up to version 1.630

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ 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)